Re: ORA-04022: nowait requested, but had to wait to lock dictionary object

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 29 Jul 2015 09:48:25 +0200
Message-ID: <55b88546$0$3374$426a74cc_at_news.free.fr>


<amazon.xia_at_gmail.com> a écrit dans le message de news: 8538221b-0e18-459a-b8c4-8d0f61e32f64_at_googlegroups.com...
| when i want to disable FK on table_t disable but recevied below error,there is no other session dml/ddl on the table at same time.
|
| alter table table_t disable constraint table_t_key;
|
| *
|
| ERROR at line 1:
|
| ORA-04022: nowait requested, but had to wait to lock dictionary object

ORA-04022: nowait requested, but had to wait to lock dictionary object  *Cause: Had to wait to lock a library object during a nowait request.  *Action: Retry the operation later.

Regards
Michel Received on Wed Jul 29 2015 - 09:48:25 CEST

Original text of this message