RE: How to drop schema that starts with a number

Did you try 

drop user "1stone" cascade;

Note the quotes around the user name.


Try this in a development database first!

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Keith Moore
Sent: Friday, October 28, 2005 11:52 AM
To: Oracle-L
Subject: How to drop schema that starts with a number

I've inherited a database with two schemas that start with a number. How
they got that way, I don't know.

Any suggestions on how to get rid of them?

Keith

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


Other related posts: