cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X

Translate the entire conversation x

Summary: Command line to drop user

Dan_Harlan
12-Amethyst

Summary: Command line to drop user

Thanks for all the help. Special thanks to Bob Lehman and Dave DeMay.
I received two solutions and they are:

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

and

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.




0 REPLIES 0
Announcements
Top Tags