Strange problem on migration, can 't create index on sys table 2006-06-02 - By Juan Carlos Reyes Pacheco
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
|
|
