OraFAQ Forum: Server Administration » ORA-00054: drop MATERIALIZED view log

Home » RDBMS Server » Server Administration » ORA-00054: drop MATERIALIZED view log (11g rel 2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00054: drop MATERIALIZED view log [message #574959]

Thu, 17 January 2013 02:58

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?

Report message to a moderator

Re: ORA-00054: drop MATERIALIZED view log [message #574961 is a reply to message #574959]

Thu, 17 January 2013 03:11

John Watson
Messages: 9003
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.

Report message to a moderator

Re: ORA-00054: drop MATERIALIZED view log [message #574964 is a reply to message #574959]

Thu, 17 January 2013 03:56

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	System tablespace resize
Next Topic:	mview to view

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 25 10:45:06 CDT 2026