Skip navigation.
Home » Blogs » rajabaskar's blog

ORA-39171: Job is experiencing a resumable wait in expdp/impdp

Submitted by rajabaskar on Thu, 2011-04-07 21:04
rajabaskar's picture

Yesterday I am importing some table data in non production database using Datapump utility. While importing the table data I am getting below error.

ORA-39171: Job is experiencing a resumable wait.
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO01'

After I am added some space to undo tablespace & import job was finished successfully.

Normally In traditional export & import (exp/imp), we will manually give the RESUMABLE_TIMEOUT parameter value (wait time for RESUMABLE) otherwise that job will fail.

If there any space issue, that job will wait for some time (what ever we gave in RESUMABLE_TIMEOUT value in seconds).But in Datapump (expdp/impdp), that job wait for some time. (There is no resumable parameter in Datapump).
I am not sure, some of the article’s say 2 hrs is default value of resumable_timeout for Datapump utility.

So I will plan to test the scenario.

DB version: 11.1.0.7
OS : Windows xp

Login as Raja user:

Step 1:

SQL> show parameter resumable

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
resumable_timeout integer 0

--create some sample tables

SQL> create table raja.test_object as select * from dba_objects;

Table created.

SQL> create table raja.test_object2 as select * from dba_objects;

Table created.

SQL> create table raja.test_baskar as select * from dba_segments;

Table created.

SQL> create table raja.test_baskar2 as select * from dba_segments;

Table created.

--Size of the Raja schema

SQL> select sum(bytes/1024/1024) from dba_segments where owner='RAJA';

SUM(BYTES/1024/1024)
--------------------
22.1875

--Take the raja schema export using datapump

C:\Documents and Settings\rajabaskar>expdp directory=DATA_PUMP_DIR dumpfile=exp_raja_schema.dmp logfile=exp_raja_schema.log schemas='RAJA'

Export: Release 11.1.0.7.0 - Production on Wednesday, 06 April, 2011 22:06:05

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Username: raja
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "RAJA"."SYS_EXPORT_SCHEMA_01": raja/******** directory=DATA_PUMP_DIR dumpfile=exp_raja_schema.dmp logfile=exp_ra
ja_schema.log schemas='RAJA'
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 22 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
. . exported "RAJA"."TEST_OBJECT" 6.929 MB 69350 rows
. . exported "RAJA"."TEST_OBJECT2" 6.929 MB 69351 rows
. . exported "RAJA"."TEST_BASKAR" 869.0 KB 7523 rows
. . exported "RAJA"."TEST_BASKAR2" 869.1 KB 7524 rows
. . exported "RAJA"."RAJA_DOCUMENTS" 0 KB 0 rows
Master table "RAJA"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for RAJA.SYS_EXPORT_SCHEMA_01 is:
D:\EXPORT\ORACLE\PRODUCT\ADMIN\TROY\DPDUMP\EXP_RAJA_SCHEMA.DMP
Job "RAJA"."SYS_EXPORT_SCHEMA_01" successfully completed at 22:06:51

Step 2:

1.I will import the raja schema to another schema
2.Create a user
3.Ensure tablespace size not enough to import the data and also make sure the datafiles are in autoextend off mode.

Note: Here Raja schema size is 22MB. Users Tablespace having only .75 MB.

SQL> select tablespace_name,file_id,bytes/1024/1024 from dba_free_space where tablespace_name='USERS';

TABLESPACE_NAME FILE_ID BYTES/1024/1024
------------------------------ ---------- ---------------
USERS 4 .75

SQL> select tablespace_name,bytes/1024/1024 from dba_data_files where tablespace_name='USERS';

TABLESPACE_NAME BYTES/1024/1024
------------------------------ ---------------
USERS 27

SQL> create user baskar
2 identified by baskar
3 default tablespace users;

User created.

SQL> grant connect,resource to baskar;

Grant succeeded.

C:\Documents and Settings\rajabaskar>impdp directory=DATA_PUMP_DIR dumpfile=exp_raja_schema.dmp logfile=imp_baskar_schema.
log remap_schema=RAJA:BASKAR

Import log

Import: Release 11.1.0.7.0 - Production on Wednesday, 06 April, 2011 22:42:10

Copyright (c) 2003, 2007, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01": sys/******** AS SYSDBA directory=DATA_PUMP_DIR dumpfile=exp_raja_schema.dmp logfile=imp_baskar_schema.log remap_schema=RAJA:BASKAR
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"BASKAR" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-31693: Table data object "BASKAR"."TEST_OBJECT" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-30032: the suspended (resumable) statement has timed out
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-31693: Table data object "BASKAR"."TEST_OBJECT2" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-30032: the suspended (resumable) statement has timed out
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-31693: Table data object "BASKAR"."TEST_BASKAR" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-30032: the suspended (resumable) statement has timed out
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
ORA-31693: Table data object "BASKAR"."TEST_BASKAR2" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-30032: the suspended (resumable) statement has timed out
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
. . imported "BASKAR"."RAJA_DOCUMENTS" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
Job "SYS"."SYS_IMPORT_FULL_01" completed with 99 error(s) at 06:42:28

*********************************************
Alert log file error:

Every 2 hours we received the error

Wed Apr 06 22:42:18 2011
DM00 started with pid=33, OS id=1588, job SYS.SYS_IMPORT_FULL_01
Wed Apr 06 22:42:18 2011
DW01 started with pid=34, OS id=3976, wid=1, job SYS.SYS_IMPORT_FULL_01
statement in resumable session 'SYS.SYS_IMPORT_FULL_01.1' was suspended due to
ORA-01653: unable to extend table BASKAR.TEST_OBJECT by 8 in tablespace USERS
Thu Apr 07 00:42:22 2011
statement in resumable session 'SYS.SYS_IMPORT_FULL_01.1' was timed out
statement in resumable session 'SYS.SYS_IMPORT_FULL_01.1' was suspended due to
ORA-01653: unable to extend table BASKAR.TEST_OBJECT2 by 8 in tablespace USERS
Thu Apr 07 02:42:24 2011
statement in resumable session 'SYS.SYS_IMPORT_FULL_01.1' was timed out
statement in resumable session 'SYS.SYS_IMPORT_FULL_01.1' was suspended due to
ORA-01653: unable to extend table BASKAR.TEST_BASKAR by 8 in tablespace USERS
Thu Apr 07 04:42:26 2011
statement in resumable session 'SYS.SYS_IMPORT_FULL_01.1' was timed out
statement in resumable session 'SYS.SYS_IMPORT_FULL_01.1' was suspended due to
ORA-01653: unable to extend table BASKAR.TEST_BASKAR2 by 8 in tablespace USERS
Thu Apr 07 06:42:28 2011
statement in resumable session 'SYS.SYS_IMPORT_FULL_01.1' was timed out

Conclusion:

1.Our import job only import object structure.

2.If there is no space, impdp is waiting for 2 hours for each object ( Not 2 hours for entire impdp job)

i.e : if there is no space, impdp attempt several times to import a first table, After 2 hours it skipped the first table & trying the second table.
Meanwhile you will add any space, import will continue from attempt table (it’s skipped the previous table & we will import the table again)

3.Every 2 hours we got information alert in alert log file.

4.Here we have import 5 tables ( 4 tables having records & 5th table having zero records, so no space required). So our impdp wait for 8 hours (4 tables * 2 hours) & finally its imported 5th table.

I Hope this article helped to you. I am expecting your suggestions/feedback.
It will help to motivate me to write more articles.

Best Regards
Rajabaskar Thangaraj
www.dbarajabaskar.blogspot.com
Mail me:

»