The error message IS ORA-942 "table or view does not exist". How/Why are you recreating the table twice again ? What is the table for ? Is it your custom table ? In your DESC, you are prepending the schema name SYS. Why are you not prepending SYS in the CREATE INDEX ?
And , finally, what are you doing with SYS objects. UNSUPPORTED. Hemant
Hi please if you can help me
I had migrated several database (without playing with hidden parameter).
But specially with one I had one problem, maybe you saw this before.
migration from 9.2 to 9.2patch4 no problem, but from patch4 to 10.2 I had this.
1) The table exists, I can do a desc, but I can't create an index on it. 2) if I execute a create table again, it executes again, no error, is this normal on sys. Thank you again
1) SQL> SELECT USER FROM DUAL; SYS -- as sysdba, I verified SQL> DESC SYS.warning_settings$; OBJ# NOT NULL NUMBER WARNING_NUM NOT NULL NUMBER GLOBAL_MOD NUMBER PROPERTY NUMBER SQL> create index i_warning_settings on warning_settings$(obj#); create index i_warning_settings on warning_settings$(obj#) * ERROR en lÝnea 1: ORA-00604: se ha producido un error a nivel 1 de SQL recursivo ORA-00942: la tabla o vista no existe 2) SQL> create table SYS.warning_settings$(obj# number not null, 2 warning_num number not null, 3 global_mod number, 4 property number);
Tabla creada.
SQL> create index i_warning_settings on warning_settings$(obj#); create index i_warning_settings on warning_settings$(obj#) * ERROR en lÝnea 1: ORA-00604: se ha producido un error a nivel 1 de SQL recursivo ORA-00942: la tabla o vista no existe
SQL> create table SYS.warning_settings$(obj# number not null, 2 warning_num number not null, 3 global_mod number, 4 property number);
Tabla creada.
SQL> create index i_warning_settings on warning_settings$(obj#); create index i_warning_settings on warning_settings$(obj#) * ERROR en lÝnea 1: ORA-00604: se ha producido un error a nivel 1 de SQL recursivo ORA-00942: la tabla o vista no existe
-- ---------------------------------------- http://www.oracleboliviaspecialists.com/
Oracle Certified Profesional 9i 10g Orace Certified Professional Developer 6i
10 years of experience from Oracle 7 to Oracle10g and developer 6i -- //www.freelists.org/webpage/oracle-l
Hemant K Chitale http://web.singnet.com.sg/~hkchital
-- //www.freelists.org/webpage/oracle-l