RE: How to drop schema that starts with a number

Problem solved.

Actually I did try that, but I didn't try:

drop user "1STONE" cascade;

DOH!

Since it's in quotes, it's case sensitive.

Keith

> 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
>
>
>


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


Other related posts: