| impdp aborting [message #212449] |
Fri, 05 January 2007 05:58  |
arsheshadri
Messages: 12
Registered: January 2006
|
Junior Member |
|
|
Hi,
I am trying to import some tables using impdp utility.
I am getting the below error while importing.
***********************************************************
An error occurred in the load as below:
Master table "SFRT"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SFRT"."SYS_IMPORT_TABLE_01":
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "SFRT"."CCDMATCHCODEEXISTINGREL" failed to
load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-30032: the suspended (resumable) statement has timed out
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
. . imported "SFRT"."CCDEXISTING" 82.63 MB 1053773 rows
Job "SFRT"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 11:43
**************************************************************
CCDMATCHCODEEXISTINGREL is an external table, and I always get the error on this table.
My temp. tablespace is of 200 MB
My database version is 10.1.0.4.0
O.S is - AIX
Is there a problem with temp tablespace? If yes what changes I can make to optimise my import?
Thanks & Regards
Sheshadri
|
|
|
|
|
|
| Re: impdp aborting [message #212582 is a reply to message #212449] |
Fri, 05 January 2007 23:47  |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
hi,
ORA-31693: Table data object string failed to load/unload and is being skipped due to error: string
Cause: Table failed to load or unload due to some error.
Action: Check load/unload error, correct problem and retry command.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
