OraFAQ Forum: Server Administration » Not Able to Delete Space below High Water Mark

Home » RDBMS Server » Server Administration » Not Able to Delete Space below High Water Mark

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Not Able to Delete Space below High Water Mark [message #60350]

Tue, 03 February 2004 01:17

Sunil
Messages: 132
Registered: September 1999

Senior Member

I am trying to deallocate the space below high water mark using the following SQL:

ALTER TABLE TEST_TABLE DALLOCATE UNUSED KEEP 6k

But the system is throwing ORA-03230 error saying: segment only contains 0 blocks of unused space above high water mark.

Error Message

ORA-03230: segment only contains 0 blocks of unused space above high water mark.

Regards

Sunil

Report message to a moderator

Re: Not Able to Delete Space below High Water Mark [message #60353 is a reply to message #60350]

Tue, 03 February 2004 02:52

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

your KEEP seems to be high.
try reducing it.
or
just move the table to the same tablespace_as_before.
it will reset the HWM.

sql> alter table mytable move tablespace Mytablespace;

Report message to a moderator