Displaying 5 results from an estimated 5 matches for "user_index".
Did you mean:
str_index
2006 Jul 04
3
OCIError: ORA-00918: column ambiguously defined
...________________________________________
# Could not dump table "region" because of following
ActiveRecord::StatementInvalid
# OCIError: ORA-00918: column ambiguously defined:
SELECT lower(i.index_name) as index_name, i.uniqueness, lowe
r(c.column_name) as column_name
FROM user_indexes i, user_ind_columns c
WHERE i.table_name = ''REGION''
AND c.index_name = i.index_name
AND i.index_name NOT IN (SELECT index_name FROM
user_constraints WHERE constraint_type = ''P'')
ORDER BY i.index_name, c.c...
2006 Feb 16
2
Ferret with relative index paths
Hi,
I have ferret working fine on my Dev machine using a relative index
path as follows:
USER_INDEX = Index::Index.new(:path => "indexes/user", :key => ''id'',
:auto_flush => true)
And the indexes/user directory is located directly off the root of my
project tree.
But when I migrate this same code to my shared TextDrive account,
Ferret cannot find the index di...
2007 Aug 24
2
error in rails 1.2.3 activerecord
...::Schema.define(:version => 2) do
# Could not dump table "users" because of following
ActiveRecord::StatementInvalid
# OCIError: ORA-00904: invalid column name: SELECT
lower(i.index_name) as index_name, i.uniqueness, lower(c.column_name) as
column_name
FROM user_indexes i, user_ind_columns c
WHERE i.table_name = ''USERS''
AND c.index_name = i.index_name
AND i.index_name NOT IN (SELECT uc.index_name FROM
user_constraints uc WHERE uc.constraint_type = ''P'')
ORDER BY i.index_n...
2006 Jul 03
9
Migrations from Mysql to Oracle. PLS HELP!
Hi all,
I''m using Rails/Mysql as development platform. the production server is
under Rails/Oracle.
Right now, i''m trying to install my application under the production
server, the connection to orcale is fine via Rails, but i have a weird
problem. example :
here is a extract from my db scheme :
Table User :_____________
id_user |
first_name |
2013 Feb 21
1
Problem with managesieve proxy
...n'
The proxy DB table looks like this:
-
-- Table structure for table `proxy`
--
CREATE TABLE IF NOT EXISTS `proxy` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` varchar(255) NOT NULL,
`email` varchar(64) NOT NULL,
`host` varchar(16) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_index` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=379 ;
--
-- Dumping data for table `proxy`
--
INSERT INTO `proxy` (`id`, `user`, `email`, `host`) VALUES
(1, 'brown', '', 'x.y.z.110'),
(2, 'fizgig', '', 'x.r.z.15'),
110 is the new d...