Home » RDBMS Server » Server Utilities » impdp aborting
impdp aborting [message #212449] Fri, 05 January 2007 05:58 Go to next message
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 #212455 is a reply to message #212449] Fri, 05 January 2007 06:12 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Increase the temp tablespace.
Re: impdp aborting [message #212582 is a reply to message #212449] Fri, 05 January 2007 23:47 Go to previous message
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.
Previous Topic: tkprof error in command prompt
Next Topic: SQL loader not loading any data
Goto Forum:
  


Current Time: Sat Dec 10 18:40:51 CST 2016

Total time taken to generate the page: 0.06927 seconds