-
drop user cascade
i want to drop the user nctexmis_test and i used the following
but i got the following error
SQL> drop user nctexmis_test cascade;
drop user nctexmis_test cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04021: timeout occurred while waiting to lock object NCTEXMIS.YRN_DELIVERY_CHALLAN_DETAIL
can anybody tell me what this error means?
-
Please look into the DBA_DDL_LOCKS view.
-
Originally Posted by M.Shakeel Azeem
i want to drop the user nctexmis_test and i used the following
but i got the following error
SQL> drop user nctexmis_test cascade;
drop user nctexmis_test cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04021: timeout occurred while waiting to lock object NCTEXMIS.YRN_DELIVERY_CHALLAN_DETAIL
can anybody tell me what this error means?
i has also faced the same error while i was trying to import the schema into separate test DB server
ORA-04021: timeout occurred while waiting to lock object NCTEXMIS.YRN_DELIVERY_CHALLAN_DETAIL
its very confusing for me why i am getting this error?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|