OraFAQ Forum: Server Administration » Drop tablespace in Oracle 8i

Home » RDBMS Server » Server Administration » Drop tablespace in Oracle 8i (oracle 8i)

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

Drop tablespace in Oracle 8i [message #395896]

Fri, 03 April 2009 00:28

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,

Report message to a moderator

Re: Drop tablespace in Oracle 8i [message #395898 is a reply to message #395896]

Fri, 03 April 2009 00:33

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Drop tablespace in Oracle 8i [message #395900 is a reply to message #395896]

Fri, 03 April 2009 00:51

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?

Report message to a moderator

Re: Drop tablespace in Oracle 8i [message #395901 is a reply to message #395896]

Fri, 03 April 2009 00:55

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Drop tablespace in Oracle 8i [message #395903 is a reply to message #395900]

Fri, 03 April 2009 01:07

Michel Cadot
Messages: 68665
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 23:39:02 CDT 2024