Home » RDBMS Server » Server Administration » ORA-00054: drop MATERIALIZED view log (11g rel 2)
ORA-00054: drop MATERIALIZED view log [message #574959] Thu, 17 January 2013 02:58 Go to next message
maninderkrb
Messages: 41
Registered: August 2012
Location: India
Member
SQL> drop MATERIALIZED view log on afccv.tbl_voicechat;
drop MATERIALIZED view log on afccv.tbl_voicechat
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired


i dont want to kill the sessions or anything
is there any way to set prority to do this task?
Re: ORA-00054: drop MATERIALIZED view log [message #574961 is a reply to message #574959] Thu, 17 January 2013 03:11 Go to previous messageGo to next message
John Watson
Messages: 4859
Registered: January 2010
Location: Global Village
Senior Member
You could quiesce the database with
alter database quiesce restricted;
then drop the log and unquiesce. Your users should notice nothing more than brief hang, unless there is some long-running query or transaction in progress.
Re: ORA-00054: drop MATERIALIZED view log [message #574964 is a reply to message #574959] Thu, 17 January 2013 03:56 Go to previous message
Michel Cadot
Messages: 59993
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
is there any way to set prority to do this task?


No.
Try to lock the table using LOCK TABLE statement.

Regards
Michel
Previous Topic: System tablespace resize
Next Topic: mview to view
Goto Forum:
  


Current Time: Fri Dec 19 11:39:39 CST 2014

Total time taken to generate the page: 0.09935 seconds