OraFAQ Forum: Server Administration » Drop TEMPORARY tablespace

Home » RDBMS Server » Server Administration » Drop TEMPORARY tablespace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Drop TEMPORARY tablespace [message #253531]

Tue, 24 July 2007 03:29

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.

Report message to a moderator

Re: Drop TEMPORARY tablespace [message #253635 is a reply to message #253531]

Tue, 24 July 2007 08:11

joy_division
Messages: 4963
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

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I think "diskgroup001" refer to ASM, so no "rm".

Regards
Michel

Report message to a moderator

Re: Drop TEMPORARY tablespace [message #253711 is a reply to message #253643]

Tue, 24 July 2007 12:32

joy_division
Messages: 4963
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.

Report message to a moderator

Previous Topic:	Materialized View
Next Topic:	RAM USAGE ON WINDOWS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 19:40:29 CDT 2024