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

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Fri, 2 Jun 2006 11:31:19 -0400
Message-ID: <cd4305c10606020831p538987b4s1021f4841e0837f6@mail.gmail.com>

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

Received on Fri Jun 02 2006 - 10:31:19 CDT