Shulou(Shulou.com)06/01 Report--

I executed an impdp, but it didn't finish because there was no space in the tablespace.

I stopped impdb, and now I need to delete the new user and the objects under it:

SQL > drop user TEST cascade

Drop user TGK_EXOR_IFIL_008_432 cascade

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

I didn't find any sessions for this user on this database:

SQL > select * from v$session where username = 'TEST'

No rows selected

Resolve:

Impdp is either still running or is rolling back the import itself.

You can try to wait for it to complete manually or terminate it. Find it:

Select o.object_name as "object_name"

S.sid as "sid"

S.serial# as "serial#"

S.username as "username"

Sq.sql_fulltext as "sql_fulltext"

From v$locked_object l, dba_objects o, v$session s

V$process p, v$sql sq

Where l.object_id = o.object_id

And l.session_id = s.sid and s.paddr = p.addr

And s.sql_address = sq.address

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.