RE: How to drop schema that starts with a number
- From: "Keith Moore" <kmoore@xxxxxxxxxxxx>
- To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx
- Date: Fri, 28 Oct 2005 11:22:39 -0500 (CDT)
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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
