OraFAQ Forum: Server Administration » gain space in table after deleting many records

Home » RDBMS Server » Server Administration » gain space in table after deleting many records

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

gain space in table after deleting many records [message #56255]

Fri, 14 March 2003 07:32

Mark
Messages: 284
Registered: July 1998

Senior Member

What is the best way to regain the space in a table after it had a huge number of records deleted (large blobs). Doing the export, then dropping the table and re-importing is one I think. Is there a better way?

I can't truncate the table as I still have records there that won't be deleted.

Report message to a moderator

Re: gain space in table after deleting many records [message #56260 is a reply to message #56255]

Fri, 14 March 2003 10:51

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

Senior Member
Account Moderator

try this

alter table < tableName > move tablespace < to_Same_tablespace_as_it_was_before >

Report message to a moderator

Previous Topic:	QUERY TUNE
Next Topic:	ORA-01031

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 02:20:47 CDT 2024