Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Oracle / Oracle Server / July 2008

Tip: Looking for answers? Try searching our database.

ORA-04021: timeout occurred while waiting to lock object

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
pejantan4u - 31 Jul 2008 11:04 GMT
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@sid file=schema.dmp

thanks
joel garry - 31 Jul 2008 18:42 GMT
> Dear gurus,
>
[quoted text clipped - 4 lines]
>
> 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.

jg
--
@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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.