Home
All Oracle Error Codes
Oracle DBA Forum

Frequent Oracle Errors

TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated

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

Juan Carlos Reyes Pacheco

2006-06-02

Replies:
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