Autoextend on, tablepace reached 99%, freespace is not available on disk

[Former Member]

Hi ,

We have a oracle database with auto extendable tablespaces. Problem is

one of the tablespace has reached 99% but hard disk is having very few

freespace. Now what should I do. Please advise.

Prabhakar

[fidel_vales]

If you do not have space on disk, the first thing would be to turn <b>OFF</b> autoextend on the datafiles for that disk.

Then allocate new datafiles on a different disk.

Or add space to the disk

[Former Member]

You might run into a situation where your database halts transactions and creates errors for the users. You could run a coalesce command at the database level to free up some extents for the users. Then you would have some time to either add another datafile on another file system or relocate some of the existing data files to a new location. You should plan on doing some of the this maintenance as soon as possible. If the one of the tablespaces has indexes - you could also run some "alter index xxx rebuild online" commands to free up some space as well.

[Former Member]

HI,

SAP Version ? .. Use brtools or sapdba (depending upo ur SAP Ver) to add and relocate new datafiles to other partition..

Regards

Umesh K