OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Backup (Oracle DB 10g R2)

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

Backup [message #518437]

Wed, 03 August 2011 22:57

mahmud732
Messages: 69
Registered: October 2009
Location: Dhaka

Member

Dear All,
When I am trying to get backup the following error occured
in a specific table.
Error Description:
ORA-00056 is means DDL lock on object 'string.string' is already held in an incompatible mode.

How can I resolve this. Please help me.

Regards

Mahmud

Report message to a moderator

Re: Backup [message #518439 is a reply to message #518437]

Wed, 03 August 2011 23:11

Michel Cadot
Messages: 54200
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Copy and paste all what you did and got.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Re: Backup [message #518440 is a reply to message #518437]

Wed, 03 August 2011 23:11

BlackSwan
Messages: 20106
Registered: January 2009

Senior Member

00056, 00000, "DDL lock on object '%s.%s' is already held in an incompatible mode"
// *Cause:  An attempt was made to acquire a DDL lock that is already locked.
// *Action: This happens if you attempt to drop a table that has parse locks
//	    on it.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Backup [message #518442 is a reply to message #518439]

Wed, 03 August 2011 23:26

mahmud732
Messages: 69
Registered: October 2009
Location: Dhaka

Member

Thanks for cooperation.
This was the execution report when i run the export command:

C:\>EXP USERID=IPL/IPLSERVER@PRAGATI TABLES=(PRBM) FILE=D:\IPL.DMP

Export: Release 9.0.1.1.1 - Production on Thu Aug 4 10:21:33 2011

(c) Copyright 2001 Oracle Corporation. All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table PRBM
EXP-00056: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00000: Export terminated unsuccessfully

C:\>

Report message to a moderator

Re: Backup [message #518443 is a reply to message #518442]

Wed, 03 August 2011 23:33

BlackSwan
Messages: 20106
Registered: January 2009

Senior Member

>Export: Release 9.0.1.1.1 - Production on Thu Aug 4 10:21:33 2011
V9.0.1 is obsoleted, unsupported & VERY BUGGY

>ORA-00056 is means DDL lock on object 'string.string' is already held in an incompatible mode.
does NOT appear & you mis-reported the actual error

export is NOT a reliable backup

when did exp last work OK?
what changed since then?

Report message to a moderator

Re: Backup [message #518454 is a reply to message #518443]

Thu, 04 August 2011 00:27

Markwillium
Messages: 12
Registered: December 2010
Location: India

Junior Member

The most possible cause for this error message might be an attempted lock is incompatible with the DDL lock already held on the object. This happens if you attempt to drop a table that has parse locks.

Resolution: Before attempting to drop a table, check that it has no parse locks. Wait a few minutes before retrying the operation

Report message to a moderator

Re: Backup [message #518467 is a reply to message #518454]

Thu, 04 August 2011 00:55

Michel Cadot
Messages: 54200
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Resolution: Before attempting to drop a table, check that it has no parse locks. Wait a few minutes before retrying the operation

Very good answer about an export! I indeed often saw an export dropping a table.

Regards
Michel

Report message to a moderator

Re: Backup [message #518468 is a reply to message #518442]

Thu, 04 August 2011 00:58

Michel Cadot
Messages: 54200
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

@mahmud732

- You didn't appropriately post, read again the guide
- What you posted has nothing to do with your first question
- EXP is NOT a database backup, question should be posted in Server Utilities forum, please take careful where you post your question

Regards
Michel

Report message to a moderator

Re: Backup [message #518532 is a reply to message #518467]

Thu, 04 August 2011 07:20

Markwillium
Messages: 12
Registered: December 2010
Location: India

Junior Member

Michel Cadot wrote on Thu, 04 August 2011 00:55

Quote:
Resolution: Before attempting to drop a table, check that it has no parse locks. Wait a few minutes before retrying the operation

Very good answer about an export! I indeed often saw an export dropping a table.

Regards
Michel

Thanks Michel.....

Report message to a moderator

Previous Topic:	Clone Database user
Next Topic:	How to move a schema to another schema in a same database?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 02:52:12 CDT 2013

Total time taken to generate the page: 0.21170 seconds