Home » RDBMS Server » Server Administration » Reuse storage of tablespace (oracle 12c - Windows server 2012)
Reuse storage of tablespace [message #622394] Tue, 26 August 2014 02:03 Go to next message
muktha_22
Messages: 397
Registered: December 2009
Senior Member
Hi,

One of my colleague had done the follow.

Truncate table... reuse storage.

Instead of Drop Storage, he did reuse.

How to rectify it, without truncate that table again.

Thanks and Regards
Muktha
Re: Reuse storage of tablespace [message #622397 is a reply to message #622394] Tue, 26 August 2014 02:14 Go to previous messageGo to next message
John Watson
Messages: 4569
Registered: January 2010
Location: Global Village
Senior Member
alter table dealloacate unused
Re: Reuse storage of tablespace [message #622441 is a reply to message #622397] Tue, 26 August 2014 08:19 Go to previous message
muktha_22
Messages: 397
Registered: December 2009
Senior Member
Hi John,

Thanks

Regards
Muktha
Previous Topic: Blocking sessions
Next Topic: Slow response during peak activity (merged)
Goto Forum:
  


Current Time: Sun Sep 21 11:57:07 CDT 2014

Total time taken to generate the page: 0.07705 seconds