Home » RDBMS Server » Backup & Recovery » Export issue
Export issue [message #249970] Fri, 06 July 2007 11:34 Go to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
Hello sir


When we try to export the schema the following error occured

EXP-00008: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [6191], [3], [3993], [4000], [], [], [], []


Export terminated successfully with warnings.


server OS: windows 32-bit
oracle version : 9.2.0.1.0


-Thanx in advance
Re: Export issue [message #249971 is a reply to message #249970] Fri, 06 July 2007 11:37 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Its seems bug.
can you post your command?
Can you able to take export any table of the same schema?
Re: Export issue [message #249980 is a reply to message #249970] Fri, 06 July 2007 12:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600 => Oracle bug => search on Metalink and/or call Oracle support.

Regards
Michel
Re: Export issue [message #249981 is a reply to message #249980] Fri, 06 July 2007 12:14 Go to previous messageGo to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
Thanx for reply

The same error not shows for other tables it dispaly one place out of full export log
If we took export for one tables it seems fine.

-Thanx
Re: Export issue [message #249982 is a reply to message #249981] Fri, 06 July 2007 12:16 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
Export terminated successfully with warnings.




How long it took?
did you try to imp that exp dump?

Re: Export issue [message #249985 is a reply to message #249982] Fri, 06 July 2007 12:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How long it took?

Long? What's the idea behind this question?

Quote:
Did you try to imp that exp dump?

I don't think a dump file is valid after an ORA-600.

Regards
Michel

[Updated on: Fri, 06 July 2007 12:29]

Report message to a moderator

Re: Export issue [message #249986 is a reply to message #249981] Fri, 06 July 2007 12:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are several bugs in 9i with direct mode, use conventional mode or upgrade to at least 9.2.0.6.

Regards
Michel
Re: Export issue [message #250842 is a reply to message #249986] Wed, 11 July 2007 09:31 Go to previous messageGo to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
Thank u for your valuable reply


May i know how to find the mode in our database there is anyway to change the mode by manually means.

_ Advance thank u sir.
Re: Export issue [message #250850 is a reply to message #250842] Wed, 11 July 2007 10:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't use "direct=y" on your export.

Regards
Michel
Re: Export issue [message #250862 is a reply to message #250850] Wed, 11 July 2007 11:27 Go to previous message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member

ok thanx sir it works



Previous Topic: online tablespace backup issue
Next Topic: Recovey db in Archivelog mode
Goto Forum:
  


Current Time: Wed May 15 11:51:36 CDT 2024