| ORA-00604 & ORA-08103 [message #62799] |
Mon, 16 August 2004 00:37  |
Jon
Messages: 483
Registered: May 2001
|
Senior Member |
|
|
1 ) When i tried to drop schema i got this error
SQL> drop user pearl cascade;
drop user pearl cascade
*
ERROR at line 1 :
ORA-00604 : error occurred at recursive SQL level 1
ORA-08103 : object no longer exists
the ora-00604 means internal error in underlying data dictionary tables where information about this schema stores
when i run full database export i got this error last
and i checked the log file.There is no error for any of the objects except this error
EXP-00056: ORACLE error 8103 encountered
ORA-08103: object no longer exists
EXP-00000: Export terminated unsuccessfull
how to fix this or what the exact reason for this
thnks in advance
jon
|
|
|
|
| Re: ORA-00604 & ORA-08103 [message #62818 is a reply to message #62799] |
Tue, 17 August 2004 06:23  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
You might have a Data Dictionary corruption. Log an iTAR with Oracle Support for assistance. They have a package that can validate the dictionary's integrity and spit out potential problems.
Best regards.
Frank
|
|
|
|
| Re: ORA-00604 & ORA-08103 [message #62819 is a reply to message #62818] |
Tue, 17 August 2004 10:36 |
Jon
Messages: 483
Registered: May 2001
|
Senior Member |
|
|
I found datafile corruption
so it tried to drop the schema and tablespace.i droped rest of the schema wihtout problem.this schema gave problem and later i created new tablespace (LMT) and created new schemas.this schema only gives the problem.
How to overcome this wheter i have to recreate the database.
pls hlp
jon
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
