junior_soares
asked on
ORA-00600: internal error code, arguments: [12700] when export dump
Hi, My database is Oracle 8.1.7 Enterprise Edition when i export dump (exp globus/pwd@ file=globus.dmp log=globus.txt the process abort with message below:
EXP-00008: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [12700], [18], [4201234], [72], [], [], [], []
EXP-00000: Export terminated unsuccessfully
I checking de trace file (ORA00340.TRC), appear de follow text:
ORA-00600: internal error code, arguments: [12700], [18], [4201234], [72], [], [], [], []
Current SQL statement for this session:
SELECT LOWNER, LIBNAME, OWNERID, FILENAME, OBJNO, AUDIT$,ISSTATIC, ISTRUSTED FROM SYS.EXU8LIBU
The oracle said: check if de data object is corrupt: (obj= EXU8LIBU).
ANALYZE TABLE EXU8LIBU VALIDATE STRUCTURE;
But this obj is a view then return error: ORA-01702: a view is not appropriate here.
How can i to solve this case?
thank´s
EXP-00008: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [12700], [18], [4201234], [72], [], [], [], []
EXP-00000: Export terminated unsuccessfully
I checking de trace file (ORA00340.TRC), appear de follow text:
ORA-00600: internal error code, arguments: [12700], [18], [4201234], [72], [], [], [], []
Current SQL statement for this session:
SELECT LOWNER, LIBNAME, OWNERID, FILENAME, OBJNO, AUDIT$,ISSTATIC, ISTRUSTED FROM SYS.EXU8LIBU
The oracle said: check if de data object is corrupt: (obj= EXU8LIBU).
ANALYZE TABLE EXU8LIBU VALIDATE STRUCTURE;
But this obj is a view then return error: ORA-01702: a view is not appropriate here.
How can i to solve this case?
thank´s
Hi
- in Oracle 8.x and 9.x, it is ORA-600 [12700][a][b][c] , where Arg [a] dataobj# from sys.obj$ Arg [b] relative dba of the data block Arg [c] slot number of the row in the data block
please run the following query, somehow I think it will return the line with the obj$ object.
select * from obj$ where dataobj# = 18
david
- in Oracle 8.x and 9.x, it is ORA-600 [12700][a][b][c] , where Arg [a] dataobj# from sys.obj$ Arg [b] relative dba of the data block Arg [c] slot number of the row in the data block
please run the following query, somehow I think it will return the line with the obj$ object.
select * from obj$ where dataobj# = 18
david
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
obj$, user$, library$ run analyze on them while I will check metalink weather any known issue exists.
david