Displaying 3 results from an estimated 3 matches for "user_ind_columns".
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.column_position
_______...
2007 Aug 24
2
error in rails 1.2.3 activerecord
...: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_name, c.column_position...
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 |