Command line to drop user

[Dan_Harlan]

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

[ksreeniv]

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

[Dan_Harlan]

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?

[ddemay]

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

[BobLehman2]

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