Home » RDBMS Server » Server Administration » Drop TEMPORARY tablespace
Drop TEMPORARY tablespace [message #253531] Tue, 24 July 2007 03:29 Go to next message
dannywcw
Messages: 24
Registered: March 2007
Junior Member
Hi i've drop the temporary tablespace "CI_TEMP" with the command
i've create a temporary table space "CI_TEMP2"
drop tablespace ci_temp;

It execute without error. But it didn't remove the CONTENTS AND DATAFILES.

So now my problem is how to remove those datafile from my diskgroup001.
Re: Drop TEMPORARY tablespace [message #253635 is a reply to message #253531] Tue, 24 July 2007 08:11 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
You have to first set the default temporary tablespace to something else.
And the proper command is
drop temporary tablespace ci_temp;

Then rm your os files.

[Updated on: Tue, 24 July 2007 08:11]

Report message to a moderator

Re: Drop TEMPORARY tablespace [message #253643 is a reply to message #253635] Tue, 24 July 2007 08:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think "diskgroup001" refer to ASM, so no "rm".

Regards
Michel
Re: Drop TEMPORARY tablespace [message #253711 is a reply to message #253643] Tue, 24 July 2007 12:32 Go to previous message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Oh, good point, but I would have to had "assumed" that since there was very little info in the posting.
Previous Topic: Materialized View
Next Topic: RAM USAGE ON WINDOWS
Goto Forum:
  


Current Time: Fri Dec 09 15:23:11 CST 2016

Total time taken to generate the page: 0.10794 seconds