RE: How to drop schema that starts with a number

Great! Was it actually named 1STONE? I was guessing!

-----Original Message-----
From: Keith Moore [mailto:kmoore_at_zephyrus.com] Sent: Friday, October 28, 2005 12:23 PM
To: Mercadante, Thomas F (LABOR)
Cc: Oracle-L
Subject: 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] 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