Pak Andes,
Coba lakukan Exp-Imp dari client 9i.
regards,
Fahmi Fahlevi
On Fri, Aug 1, 2008 at 10:46 AM, Andes Febrian <[EMAIL PROTECTED]> wrote:
> wahh klo ini bugs, gimana cara mengatasi masalah ini ?
>
> any suggestion ?
>
> thanks.
>
> On 8/1/08, Wahyudinata Herry <[EMAIL PROTECTED]<hwahyudinata%40yahoo.com>>
> wrote:
> >
> > 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]<pejantan4u%40gmail.com>
> <pejantan4u%40gmail.com>>
> > wrote:
> >
> > From: Andes Febrian <[EMAIL PROTECTED] <pejantan4u%40gmail.com><pejantan4u%
> 40gmail.com>>
> > Subject: [indo-oracle] Eror waktu export schema
> > To: [email protected] <indo-oracle%40yahoogroups.com><indo-oracle%
> 40yahoogroups.com>
>
> > 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]
> >
> >
> >
>
> --
> Cheers,
> ^_^ Andes ^_^
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]
