sql - drop user ORA-00604 and ORA-00054 -


i execute impdp, not finish because there isnt space in tablespace.

i stop impdb , need drop new schema , use command:

sql> drop user test cascade; drop user tgk_exor_ifil_008_432 cascade * error @ line 1: ora-00604: error occurred @ recursive sql level 1 ora-00054: resource busy , acquire nowait specified or timeout expired 

i dont find lock on database schema:

sql> select * v$session username = 'test';  no rows selected 

i use oracle 11g

the impdp either still running or rolling import itself.
can try , wait finish or kill manually. find this:

select o.object_name "object_name",        s.sid "sid",        s.serial# "serial#",        s.username "username",        sq.sql_fulltext "sql_fulltext"   v$locked_object l, dba_objects o, v$session s,        v$process p, v$sql sq   l.object_id = o.object_id     , l.session_id = s.sid , s.paddr = p.addr     , s.sql_address = sq.address; 

credit
after finding object locked can kill sid.
or if table holding can mark read only:

alter table table_name read only; 

Comments

Popular posts from this blog

java - Oracle EBS .ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class ERROR -

c# - how to use buttonedit in devexpress gridcontrol -

nvd3.js - angularjs-nvd3-directives setting color in legend as well as in chart elements -