Re: ORA-04021: timeout occurred while waiting to lock object

From: joel garry <>
Date: Thu, 31 Jul 2008 10:42:30 -0700 (PDT)
Message-ID: <>

On Jul 31, 3:04 am, pejantan4u <> wrote:
> Dear gurus,
> I had this message when i tried to export a schema, please tell me why
> this happens?
> i ran this script, exp schema/schema_at_sid file=schema.dmp
> thanks

Oracle 9 and 10 should have an object identifier at the end of the error to give you a clue. You can also use various scripts or tools to see what is locked. It helps to say your exact version, there's an O9 bug having to do with compiling pl/sql, another one with smon locking undo (which might show up if you have read consistency issues trying to export while others update). 10.1 has a bug if you are doing any DDL while exporting, see Note:298968.1.

Metalink Note: 169139.1 is the basic description on how to figure out the problem. It's best to do exports when no one is on, and check the utilities manual for the consistent parameter.


-- is bogus.  “We have a saying out here in rural California:
'If you need a hip replacement, commit a felony,' ” - Charles
Guenther, noting that prisons are under court order to improve medical
care, while the state isn't paying Medi-Cal hospitals because of the
budget deadlock.
Received on Thu Jul 31 2008 - 12:42:30 CDT

Original text of this message