Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00600 during schema export Oracle 8.1.5

Re: ORA-00600 during schema export Oracle 8.1.5

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 11 Sep 2002 08:50:36 +0100
Message-ID: <3d7ef5cc$0$8511$cc9e4d1f@news.dial.pipex.com>

"Igor Smaglyuk 1293309929" <siv_at_emt.com.ua> wrote in message news:1031727543.218352_at_fobos.ldc.net...
> Hi, ALL!
>
> Help me!
>
> I have Oracle 8.1.5 (Linux). I was exporting a schema.
> Tables exported normally. But during export of views the error ORA-00600
> appeared.

<snip>

> Current SQL statement for this session:
> SELECT TOWNER,TNAME,NAME,LENGTH,PRECISION,SCALE,TYPE,ISNULL,CONNAME,COLID,
> INTCOLID, SEGCOLID, COMMENT$,DEFAULT$, DFLTLEN, ENABLED, DEFER,
> FLAGS,
> COLPROP, ADTNAME, ADTOWNER, CHARSETID, CHARSETFORM, FSPRECISION,
> LFPRECISION FROM SYS.EXU8COLU WHERE TOBJID = :1 ORDER BY INTCOLID
>
> What's wrong?

What is wrong is that you have reached an unhandled exception. You will need to open a support call with Oracle. I would suggest first that you run the sql listed above in sql*plus and see if it also errors.

The particular exception you have received appears to indicate possible data corruption in your system tablespace so a support call is even more important. If you have a support contract note 155933.1 on metalink will give you more information.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Wed Sep 11 2002 - 02:50:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US