Dear Andes
 
EXP-0056-- 4021 encountered
ada library object yang ke lock saat dilakukan export
 
ini bugs di 10.1, dan di perbaiki di version 10.2
 
maybe ada cara lain yang lebih instants?
 
regards
herry

--- On Thu, 7/31/08, Andes Febrian <[EMAIL PROTECTED]> wrote:

From: Andes Febrian <[EMAIL PROTECTED]>
Subject: [indo-oracle] Eror waktu export schema
To: [email protected]
Date: Thursday, July 31, 2008, 11:10 PM






Dear gurus,

Need help, ketika export satu schema di database 10.1.0.2.0, terdapat
message eror dibawah ini :

*Code:*
C:\>exp vpndb/vpndb@ solusi file=e:\dailybackup \vpnbak010808. dmp

Export: Release 10.1.0.2.0 - Production on Fri Aug 1 09:31:48 2008

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 -
Produc
tion
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user VPNDB
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user VPNDB
About to export VPNDB's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 4021 encountered
ORA-04021: timeout occurred while waiting to lock object
ORA-06512: at "SYS.DBMS_METADATA" , line 1511
ORA-06512: at "SYS.DBMS_METADATA" , line 1548
ORA-06512: at "SYS.DBMS_METADATA" , line 1864
ORA-06512: at "SYS.DBMS_METADATA" , line 3707
ORA-06512: at "SYS.DBMS_METADATA" , line 3689
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

sepertinya ada yg ke-lock, tp sudah saya liat di v$lock, kemudian saya kill,
masih aja ga bisa. mohon pencerahannya, thanks

-- 
Cheers,
^_^ Andes ^_^

[Non-text portions of this message have been removed]

 














      

[Non-text portions of this message have been removed]

Kirim email ke