thanks pak rohmad atas info nya, sudah saya kill. tapi ketika saya ingin export lagi, kembali ngga bisa, proses export stuck seperti dibawah ini :
C:\>orakill SOLUSI 5652 Kill of thread id 5652 in instance SOLUSI successfully signalled. C:\>exp vpndb/[EMAIL PROTECTED] file=e:\dailybackup\vpnbak010808.dmp Export: Release 10.1.0.2.0 - Production on Fri Aug 1 10:39:39 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 stuck sampai sini dan harus menunggu lama, setelah menunggu lama kemudian muncul error message sama seperti di atas. mohon pencerahannya. On 8/1/08, rohmadsan <[EMAIL PROTECTED]> wrote: > > Hallo... > > Gunakan SQL command berikut untuk melihat object yang ter-lock dan > session yang nge-lockt: > > SELECT p.spid,a.session_id, b.serial#, b.status, a.oracle_username, > a.os_user_name, > a.process, c.name,b.event, b.SECONDS_IN_WAIT "Wait(Seconds)" > FROM sys.obj$ c, v$session b, v$locked_object a, v$process p > WHERE a.session_id=b.sid > AND b.paddr = p.addr > AND c.obj#=a.object_id order by b.SECONDS_IN_WAIT desc > ; > > Kadang-kadang info dari v$lock saja tidak cukup. > Setelah session di-kill, lihat lagi status di v$session; kalao masih > ada dengan status "KILLED", kill saja dari OS. > > Referensi: > http://oracleku.blogspot.com/2008/04/kill-hung-session.html > > Salam, > Rohmad > > --- In [email protected] <indo-oracle%40yahoogroups.com>, "Andes > Febrian" <[EMAIL PROTECTED]> > wrote: > > > > Dear gurus, > > > > Need help, ketika export satu schema di database 10.1.0.2.0, terdapat > > message eror dibawah ini : > > > > *Code:* > > C:\>exp vpndb/[EMAIL PROTECTED] 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] > > > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
