OraFAQ Forum: Server Administration » how to remove a entire schema

Home » RDBMS Server » Server Administration » how to remove a entire schema

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

how to remove a entire schema [message #227648]

Wed, 28 March 2007 20:33

freethinking
Messages: 10
Registered: November 2006

Junior Member

hi dear friends ,is there a good way to remove a entire schema
thanks...

Report message to a moderator

Re: how to remove a entire schema [message #227649 is a reply to message #227648]

Wed, 28 March 2007 20:57

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

drop user username cascade;

Report message to a moderator

Re: how to remove a entire schema [message #227650 is a reply to message #227648]

Wed, 28 March 2007 20:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

The answer to this and any other SQL question can be found in the fine SQL Reference manual.
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9008.htm#sthref8847

Report message to a moderator

Re: how to remove a entire schema [message #227652 is a reply to message #227648]

Wed, 28 March 2007 21:32

freethinking
Messages: 10
Registered: November 2006

Junior Member

appreicate for all your kindly quick reply,
I know there are my answer in the manual,but for lack of basic knowlage of oracle , some times it take me long time to locate it Embarassed

Regards

Report message to a moderator

Re: how to remove a entire schema [message #227653 is a reply to message #227648]

Wed, 28 March 2007 22:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

There are two kinds of people.
Those who think they can & those who think they can't.
Both are correct.

Report message to a moderator

Re: how to remove a entire schema [message #227655 is a reply to message #227648]

Wed, 28 March 2007 22:35

freethinking
Messages: 10
Registered: November 2006

Junior Member

hi dude , I think you are the type who think they can,please don't ask anybody, don't discuss anything with any expert,becaus every thing you will find in the manual.
if it make you feel bad for you read my question,I am sorry but I think it's better to find the reason in yourself , you can create a poll to test it Smile

by the way I am the best guy who can find help in oracle manual in our team,I am just a developer who want learn more about oracle.
thanks again for your answer

Report message to a moderator

Re: how to remove a entire schema [message #228073 is a reply to message #227655]

Sat, 31 March 2007 04:16

muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh

Senior Member

First drop the user
then drop the tablespaces associate with the users

drop user ur_schema cascade;

drop tablespace ur_tablespace including contents and datafiles;

Report message to a moderator

Re: how to remove a entire schema [message #228116 is a reply to message #227648]

Sat, 31 March 2007 21:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

muzahidul islam posted:
>First drop the user
>then drop the tablespaces associate with the users
Tablespaces are NOT/NEVER "associate[d] [sic] with the users"
What happens when objects of multiple schemas coexist within a single tablespace & you are to drop only one of the schemas?

Report message to a moderator

Previous Topic:	ORA-01031
Next Topic:	EXTRACT FROM REDOLOG FILE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:53:05 CDT 2024