ORA-39171: Job is experiencing a resumable wait.

ORA-39171: Job is experiencing a resumable wait.

Together with

ORA-01653: Unable to extend table %s.%s by %s in tablespace %s
Or
ORA-01691 unable to extend lob segment string.string by string in tablespace string

Steps to follows:

1. Check the data files details of the tablespace

select * from dba_data_files where tablespace_name='TABLESPACE_NAME';

2. Data Pump Restart Capability:
1) In the IMPDP window, click CTRL-C to stop the job.
2) In the command line type:

Import> stop_job=immediate

3)Use SQLPlUS to make the required changes to the table space.

a) Add DataFile
ALTER TABLESPACE ADD DATAFILE ' ' SIZE M;

b) Resize the Datafile:
ALTER DATABASE DATAFILE ' ' RESIZE M;

c) Enable autoextend:
ALTER DATABASE DATAFILE ' ' AUTOEXTEND ON MAXSIZE UNLIMITED;

4) Attach the Job.

impdp system/manager attach=Job_Name

If you did not provide a specific job name when you first ran the IMPDP, Oracle will assign a default name for it. In order to find the System assigned name for the IMPDP job you can run the following query:

SELECT * FROM DBA_DATAPUMP_JOBS;

The result will probably be something like SYS_IMPORT_FULL_number.

5) Restart the job

Import> start_job

6) You can check the status of the job by simply typing STATUS in the utility
command prompt.


Import> status

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s