RE: index whose next extent is larger than the largest free exten t av ailable in their tablespace

From: Ashish Shah <ar_shah_at_yahoo.com>
Date: Fri, 11 Aug 2000 07:40:02 -0700 (PDT)
Message-Id: <10586.114359@fatcity.com>

or you can make auto-extend on on the datafile that belong to index tablespace. Make sure you have enough free space on unix/nt file system.

• Rahul <rahul_at_ratelindo.co.id> wrote:
  > 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
  > >
  >
  > --------
  > 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
  >
  

  ---

Ashish
Toronto, Canada

---

Do You Yahoo!?
Kick off your party with Yahoo! Invites. Received on Fri Aug 11 2000 - 09:40:02 CDT