Home » RDBMS Server » Server Administration » Urgent: Removing tablespace
Urgent: Removing tablespace [message #298840] Fri, 08 February 2008 00:08 Go to next message
svik
Messages: 16
Registered: April 2005
Location: MRU
Junior Member
What will be the effect of deleting a particular tablespace from a database? Want to do this just to free some disk space since all the objects within the tbs are not used. Will the database function properly after start up?. I will store it as a backup so that it can used for reference later.

Thanks.

[Updated on: Fri, 08 February 2008 00:45]

Report message to a moderator

Re: Urgent: Removing tablespace [message #298855 is a reply to message #298840] Fri, 08 February 2008 00:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Dropping a tablespace implies dropping all objects it contains.
You don't need to restart.

After dropping a tablespace you can't "reinsert" it.

Regards
Michel

[Updated on: Fri, 08 February 2008 00:48]

Report message to a moderator

Re: Urgent: Removing tablespace [message #299107 is a reply to message #298840] Sat, 09 February 2008 08:03 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

It is better if you take export tablespace before droping for backup purpose.
Previous Topic: Old sql problem
Next Topic: run exp cmd in shell scripts
Goto Forum:
  


Current Time: Tue Dec 06 08:38:57 CST 2016

Total time taken to generate the page: 0.17946 seconds