Home » RDBMS Server » Server Administration » Drop tablespace in Oracle 8i (oracle 8i)
Drop tablespace in Oracle 8i [message #395896] Fri, 03 April 2009 00:28 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I want to know how to drop tablespace in Oracle 8i.

Actually i read on internet that we cannot drop tablespace in oracle 8i.
Is that true?

How can i drop the tablespace in 8i?

Thanks,


Re: Drop tablespace in Oracle 8i [message #395898 is a reply to message #395896] Fri, 03 April 2009 00:33 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>I want to know how to drop tablespace in Oracle 8i.
DROP TABLESPACE...

>Actually i read on internet that we cannot drop tablespace in oracle 8i. Is that true?
No

>How can i drop the tablespace in 8i?
What have you tried & what was the results?

Re: Drop tablespace in Oracle 8i [message #395900 is a reply to message #395896] Fri, 03 April 2009 00:51 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Actually what information i got is that,

8i does have a DROP TABLESPACE command. What it does not have is the "AND DATAFILES" clause. Thus, it will not remove the datafiles at the OS layer (eg filesystem).

How can i remove space then?
Re: Drop tablespace in Oracle 8i [message #395901 is a reply to message #395896] Fri, 03 April 2009 00:55 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.
Re: Drop tablespace in Oracle 8i [message #395903 is a reply to message #395900] Fri, 03 April 2009 01:07 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How can i remove space then?

Use rm/del OS command.

Regards
Michel
Previous Topic: monitoring tool
Next Topic: Sequence giving me ora-00001 ? (unique constraint violated)
Goto Forum:
  


Current Time: Thu Dec 08 15:56:58 CST 2016

Total time taken to generate the page: 0.12582 seconds