Home » RDBMS Server » Server Administration » how to remove a entire schema
icon5.gif  how to remove a entire schema [message #227648] Wed, 28 March 2007 20:33 Go to next message
freethinking
Messages: 10
Registered: November 2006
Junior Member
hi dear friends ,is there a good way to remove a entire schema
thanks...
Re: how to remove a entire schema [message #227649 is a reply to message #227648] Wed, 28 March 2007 20:57 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
drop user username cascade;
Re: how to remove a entire schema [message #227650 is a reply to message #227648] Wed, 28 March 2007 20:58 Go to previous messageGo to next message
BlackSwan
Messages: 25041
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
Re: how to remove a entire schema [message #227652 is a reply to message #227648] Wed, 28 March 2007 21:32 Go to previous messageGo to next message
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

Re: how to remove a entire schema [message #227653 is a reply to message #227648] Wed, 28 March 2007 22:03 Go to previous messageGo to next message
BlackSwan
Messages: 25041
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.
Re: how to remove a entire schema [message #227655 is a reply to message #227648] Wed, 28 March 2007 22:35 Go to previous messageGo to next message
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
Re: how to remove a entire schema [message #228073 is a reply to message #227655] Sat, 31 March 2007 04:16 Go to previous messageGo to next message
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;



Re: how to remove a entire schema [message #228116 is a reply to message #227648] Sat, 31 March 2007 21:38 Go to previous message
BlackSwan
Messages: 25041
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?
Previous Topic: ORA-01031
Next Topic: EXTRACT FROM REDOLOG FILE
Goto Forum:
  


Current Time: Tue Dec 06 12:08:44 CST 2016

Total time taken to generate the page: 0.09324 seconds