Re: Strange problem on migration, can't create index on sys table

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

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: 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
>--
>http://www.freelists.org/webpage/oracle-l
>

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--
http://www.freelists.org/webpage/oracle-l