RE: index whose next extent is larger than the largest free exten

if you dont have a required size extent then the next time the index tries to allocate a new extent, oracle will returns an error "unable to extend...."
one way is to alter the storage and make the NEXT extent smaller. (rebuild ?)
ur tbs could also be fragmented....

Rahul

> ----------
> From: 135 Shen, Grace[SMTP:ying_at_optoma.com.tw]
> Sent: Friday, August 11, 2000 10:14 AM
> To: oracledba_at_lazydba.com
> Subject: index whose next extent is larger than the largest free extent av ailable in their tablespace
>
> Hi, DBAs,
>
> If there are indexes whoes next extent is larger
> than the largest free extent available in their tablespace,
> what is the best way to solve this problem?
> And if this problem won't be solved, what will happen?
>
> ps: There still have a lot free space of this tablespace(480MB).
>
> Thanks a lot!
>
>
> Grace
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Fri Aug 11 2000 - 01:04:20 CDT