Re: exp getting ora600 and exp 00008 error

Steve Robin wrote:
> while exp full database
> I am getting
>
> . . exporting table SC_BLOB_OBJ
> EXP-00008: ORACLE error 600 encountered
> ORA-00600: internal error code, arguments: [6193], [4], [2120], [4002],
> [7061], [], [], []
>
> this table contain only 2 cols
>
> SQL> desc SC_BLOB_OBJ
> Name Null? Type
> -------------------------------------------------- ----------------
> -------------------------
> GID NOT NULL VARCHAR2(34)
> DATA LONG
> RAW
>
> SQL> select count(1) from SC_BLOB_OBJ;
>
> COUNT(1)
> ------------------
> 276487
>
> Database : 9.2.0.1
> Platform : Windows XP
>
> What could be the problem here and how to solve it.
>

Are you using Direct Path for your export (DIRECT=Y)? If so, try it without Direct Path.

Otherwise, there are a few known bugs for the ORA-600 [6193] error. Apply the latest patchset and this should go away. If not, file a Service Request with Oracle Support.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown