Info aja nie pak, mungkin kasusnya sama seperti ini http://www.dbasupport.com/forums/archive/index.php/t-34497.html
--- On Thu, 7/31/08, Andes Febrian <[EMAIL PROTECTED]> wrote: From: Andes Febrian <[EMAIL PROTECTED]> Subject: Re: [indo-oracle] Eror waktu export schema To: [email protected] Date: Thursday, July 31, 2008, 9:53 PM belum pak, database masih 10.1.0.2.0. maksud migrate ini saya harus punya database patch 10.1.0.3 kan pak ? saya tidak punya. On 8/1/08, Wahyudinata Herry <hwahyudinata@ yahoo.com> wrote: > > Dear Andes > > Mungkin ini share saja, pa andes sudah menaikan patch oracle menjadi > 10.1.0.3, > apakah bapa sudah memigrate database bapa menjadi 10.1.0.3? > sql>startup migrate > sql>utlirp.sql > sql>catpatch. sql > sql>utlrp.sql > > > --- On Thu, 7/31/08, Andes Febrian <[EMAIL PROTECTED] com<pejantan4u% > 40gmail.com> > > wrote: > > From: Andes Febrian <[EMAIL PROTECTED] com <pejantan4u% 40gmail.com> > > Subject: Re: [indo-oracle] Eror waktu export schema > To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > Date: Thursday, July 31, 2008, 11:59 PM > > bukan, saya hanya mau export satu schema saja. > > ok thanks to all. > > saya coba liat di metalink > > On 8/1/08, hendra chen <h3ndr4ch3n@ yahoo. com.sg> wrote: > > > > ya apply patch untuk mengatasi bug ini, > > untuk lebih aman nya, coba bapak create SR ke metalink tanyakan apa bener > > ini bug, jika bener apa patch nya untuk mengatasi nya. > > > > bapak ini mau export semua schema ya? dan import ke db lain kan ? > > kl iya, bapak coba aja gunakan cara backup & restore, kl bapak butuh > cepat. > > > > --- On Fri, 1/8/08, Andes Febrian <pejantan4u@ gmail. com<pejantan4u% > 40gmail.com> > > > wrote: > > From: Andes Febrian <pejantan4u@ gmail. com <pejantan4u% 40gmail.com> > > > Subject: Re: [indo-oracle] Eror waktu export schema > > To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > > Date: Friday, 1 August, 2008, 10:46 AM > > > > wahh klo ini bugs, gimana cara mengatasi masalah ini ? > > > > any suggestion ? > > > > thanks. > > > > On 8/1/08, Wahyudinata Herry <hwahyudinata@ yahoo.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 <pejantan4u@ gmail. com<pejantan4u% > > 40gmail.com> > > > > > > wrote: > > > > > > > > > > From: Andes Febrian <pejantan4u@ gmail. com <pejantan4u% 40gmail.com> > > > > > > > Subject: [indo-oracle] Eror waktu export schema > > > > > To: indo-oracle@ yahoogroups. 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] > > > > > > > > > > > > > > > > > > > > > > > > New Email addresses available on Yahoo! > > Get the Email name you've always wanted on the new @ymail and > > @rocketmail. > > Hurry before someone else does! > > http://mail. promotions. yahoo.com/ newdomains/ sg/ > > > > [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] > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
