anxious! Advice: how to delete the database

styork

After I created an expert / adon account, I used imp to import the backup directly. Now I want to delete the imported database. What can I do?

whbilly

Batch processing
select 'drop' || owner || '.' || object_name || 'cascade;' from dba_objects;

Just execute the batch script

styork

Checked on Baidu:
connect internal;
drop user user_name cascade;

whbilly

Also, the same

wepengskywz

Log in with the system administrator,
sqlplus /nolog
connect /as sysdba
Then use the drop command:
drop user expert cascade
Can

plmsyz007

Agree, it is faster to delete users directly!


[Quote=Quote the reply fromwepengskywzon the 4th floor:]
Log in with the system administrator,
sqlplus /nolog
connect /as sysdba
Then use the drop command:
drop user expert cascade
Can
[/Quote]

wj_loves

Several methods are feasible, it is more convenient to have DROP in ORACLE