Skip to main content
Dan_Harlan1-Visitor
1-Visitor
July 19, 2010
Question

Command line to drop user

I'm looking for a dos command line to drop the windchill user from
Oracle 10gR2. I expect the command to be something like (but would
rather not test something untried):

/drop pdmlink/pdmlink@wind cascade
/


TIA, will post answer.

--
~Dan

Dan Harlan
602.320.4187

4 replies

ksreeniv1-Visitor
1-Visitor
July 19, 2010
AFter logging into sqlplus using system account (e.g. sqlplus
system/manager@wind) , "drop user username cascade" will work. No need to
enter password.

Translate
Dan_Harlan1-VisitorAuthor
1-Visitor
July 19, 2010
Thanks for all the feedback. I'm looking to do this entirely in DOS,
not after logging into sqlplus. I am looking to do this as part of an
automated script.

Perhaps I can do the same thing during a command line import? i.e. have
it overwrite (and not append) when doing the import?



Translate
ddemay1-Visitor
1-Visitor
July 19, 2010
In that case you need the sqlplus flag to run a sql file from command line and you place the commands in the sql file. Bada bing. Oracle website or typing sqlplus will tell you what command/parameter flag to use.


Sent from my Verizon Wireless BlackBerry
Translate
BobLehman212-Amethyst
12-Amethyst
July 19, 2010

echo drop user username cascade ; | sqlplus wcadmin/wcadmin@wind

This assumes a password and user of wcadmin and a db name of win -
technically a TNS name of wind. Change appropriatly

If you are running unix add quotes

echo "drop user username cascade ;" | sqlplus wcadmin/wcadmin@wind


Should work
--Bob


Translate
Terms & ConditionsAccessibility statement