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: 527
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

Report message to a moderator

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: 8968
Registered: January 2010
Location: Global Village
Senior Member
alter table dealloacate unused

Report message to a moderator

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: 527
Registered: December 2009
Senior Member
Hi John,

Thanks

Regards
Muktha

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Mar 11 06:40:00 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.