Re: strange error ora-00604 01578 01110

"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