NEGATIVE Tablespace Size

November 7, 2008 at 4:08 pm (Oracle Survive) (, , )

One day..
Enterprise Manager Console also another monitor tools shows Data and index tablespace size’s are negative. You can add another datafile or move another tablespace your tables or indexes.There is no change. So what must you do ?

SQL> Purge Dba_recyclebin;

Note: Check out your recyclebin BIN$ objects if it has neccessary one.

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.