Re: ORA-04021: timeout occurred while waiting to lock object
Date: Thu, 31 Jul 2008 10:42:30 -0700 (PDT)
On Jul 31, 3:04 am, pejantan4u <pejanta..._at_gmail.com> 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
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.
-- @home.com 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