Home » RDBMS Server » Server Utilities » Re: Releasing the Table space after /while deleting records
Re: Releasing the Table space after /while deleting records [message #70743] Fri, 19 July 2002 15:28
ctg
Messages: 146
Registered: July 2002
Senior Member
The only way to release USED space from a table is to truncate the table. But trucating a table does not cause the table to go offline. And truncating is faster then a mass delete, but it is not recoverable. Once you truncate the data is gone, no rollback.

Report message to a moderator

Previous Topic: Re: New sqlldr user having problems loading date column
Next Topic: Releasing the Table space after /while deleting records
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 03 11:35:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.