The error message IS ORA-942 (See ORA-942.ora-code.com) "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
At 11:31 PM Friday, Juan Carlos Reyes Pacheco wrote: >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 (See ORA-00604.ora-code.com): se ha producido un error a nivel 1 de SQL recursivo >ORA-00942 (See ORA-00942.ora-code.com): 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 (See ORA-00604.ora-code.com): se ha producido un error a nivel 1 de SQL recursivo >ORA-00942 (See ORA-00942.ora-code.com): 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 (See ORA-00604.ora-code.com): se ha producido un error a nivel 1 de SQL recursivo >ORA-00942 (See ORA-00942.ora-code.com): 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 >-- >http://www.freelists.org/webpage/oracle-l >
Hemant K Chitale http://web.singnet.com.sg/~hkchital
