Home » RDBMS Server » Server Utilities » IMPDP hangs (10.2.0.4)
IMPDP hangs [message #518564] |
Thu, 04 August 2011 12:21  |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
Experts,
I am using expdp/impdp to migrate 4 TB database from solaris
to Linux.But the import process is taking forever.
Can you please tell me any other methods for migrating.
Thanks,
Varun
|
|
|
|
|
|
|
|
|
|
|
Re: IMPDP hangs/oracle10g/windowsXP [message #571279 is a reply to message #571220] |
Thu, 22 November 2012 22:41   |
prejib
Messages: 126 Registered: March 2009 Location: India
|
Senior Member |
|
|
Hi,
The hanging at the place of index of impdp process is solved by adding tablespace . Actually I am importing only metadata and enough space was also there in the tablespace alloted , again it shows the error 'ORA-01659: unable to allocate MINEXTENTS beyond string in tablespace string '. Now the impdp statement got end with the below error :
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/POST_TABLE_ACTION
Processing object type SCHEMA_EXPORT/TABLE/MATERIALIZED_VIEW_LOG
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
Job "SYSTEM"."SYS_IMPORT_SCHEMA_02" stopped due to fatal error at 10:05:53
in the alert_orcl.log , the error is
Errors in file e:\tools\oracle10g_ee\oracle\product\10.2.0\db_1\admin\orcl\bdump\orcl_dw01_5956.trc:
ORA-00600: internal error code, arguments: [kkzlcsl-1], [0], [], [], [], [], [], []
|
|
|
|
|
|
|
Goto Forum:
Current Time: Wed Jul 09 14:50:32 CDT 2025
|