Home » RDBMS Server » Server Utilities » Backup (Oracle DB 10g R2)
Backup [message #518437] Wed, 03 August 2011 22:57 Go to next message
mahmud732
Messages: 73
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
Re: Backup [message #518439 is a reply to message #518437] Wed, 03 August 2011 23:11 Go to previous messageGo to next message
Michel Cadot
Messages: 58481
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
Re: Backup [message #518440 is a reply to message #518437] Wed, 03 August 2011 23:11 Go to previous messageGo to next message
BlackSwan
Messages: 22472
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/
Re: Backup [message #518442 is a reply to message #518439] Wed, 03 August 2011 23:26 Go to previous messageGo to next message
mahmud732
Messages: 73
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:\>
Re: Backup [message #518443 is a reply to message #518442] Wed, 03 August 2011 23:33 Go to previous messageGo to next message
BlackSwan
Messages: 22472
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?
Re: Backup [message #518454 is a reply to message #518443] Thu, 04 August 2011 00:27 Go to previous messageGo to next message
Markwillium
Messages: 13
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
Re: Backup [message #518467 is a reply to message #518454] Thu, 04 August 2011 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 58481
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
Re: Backup [message #518468 is a reply to message #518442] Thu, 04 August 2011 00:58 Go to previous messageGo to next message
Michel Cadot
Messages: 58481
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


Re: Backup [message #518532 is a reply to message #518467] Thu, 04 August 2011 07:20 Go to previous message
Markwillium
Messages: 13
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.....
Previous Topic: Clone Database user
Next Topic: How to move a schema to another schema in a same database?
Goto Forum:
  


Current Time: Tue Jul 22 08:34:15 CDT 2014

Total time taken to generate the page: 0.09733 seconds