Re: strange error ora-00604 01578 01110

Hello,

The table affected is IDL_CHARS in SYSTEM. As it is not an Index, does that mean that I have to drop the whole db and rebuild an new one??

Thanks,

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> a écrit dans le message news: ueaju8rmoma833_at_corp.supernews.com...
>
> "Marc Hoang" <marc.hoang_at_asterop.com> wrote in message
> news:ac3c66$20$1_at_reader1.imaginet.fr...
> > Thank you for your quick answer.
> >
> > Excuse me, I am quite a new with Oracle.. How do I check dba_extents?
> >
> > Have a nice week-end! Ours in France is till Tuesday ;-p
> >
> > Marc Hoang
> >
> > > >
> > >
> > > You are using the wrong dictionary view. You should check dba_extents.
> > >
> > > Hth
> > >
> > > Sybrand Bakker, Senior Oracle DBA
> > >
> > > To reply remove -verwijderdit from my e-mail address
> >
> >
>
> The basic columns are the file_id, the block_id and the blocks column
> specifying the size of the extent
> So your block no should be between block_id and block_id + blocks
> Of course you can always
> describe dba_extents
> or
> select * from dict_columns where table_name = 'DBA_EXTENTS'
>
> Fortunately the weekend is here, because of Whitsun, also three days.
> Hopefully it is not going to rain, I need to visit a huge gardening shop.
> Have a nice weekend too
>
> Regards
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
>
Received on Tue May 21 2002 - 02:54:31 CDT