RE: How to drop schema that starts with a number

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Fri, 28 Oct 2005 12:07:11 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF35FD86@EXCNYSM0A1AJ.nysemail.nyenet>

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 Received on Fri Oct 28 2005 - 11:09:36 CDT