[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2421
  • Last Modified:

ORA-39171: Job is experiencing a resumable wait.

Hi,
Please suggest me on this error.I am getting this error while importing the table from one database to another database.
Import sytax is this
*************************************************************************************************
impdp test/******* tables=audit_lo
gs directory=datapump_test dumpfile=audit_logs_test.dmp logfile=audit_logs_test.log
 remap_schema=audit_logs:report_audits table_exists_action=append
remap_tablespace=master_data:audit_rpt_data
*******************************************************************************************************



ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table REPORT_AUDITS.AUDIT_LOGS by 8192 in tablespace AUDIT_RPT_DATA
0
Cha1tu
Asked:
Cha1tu
  • 4
  • 2
3 Solutions
 
johnsoneSenior Oracle DBACommented:
Most likely your AUDIT_RPT_DATA tablespace is full.

You will either need to set autoextend on for a file or files, add a file, or extend an existing file.
0
 
Cha1tuAuthor Commented:
I already added the datafiles to audit_rpt_data but still i am getting this error
0
 
johnsoneSenior Oracle DBACommented:
After adding datafiles, it the processes getting further before it gets the error, or does it get the error immediately every time.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
Cha1tuAuthor Commented:
every time i am getting same type error .After starting the import
0
 
johnsoneSenior Oracle DBACommented:
What is the result of these queries:

select file_id, blocks, autoextensible, maxblocks from dba_data_files where tablespace_name = 'AUDIT_RPT_DATA';

select file_id, sum(blocks) from dba_free_space where tablespace_name = 'AUDIT_RPT_DATA' group by file_id;


How large is the table that you are trying to import?
0
 
Aaron ShiloCommented:
hi

you should check the MAXEXTENTS parameter for the tablespace and table it seems that you reached the maximum.
0
 
johnsoneSenior Oracle DBACommented:
I do not believe this has to do with exceeding MAXEXTENTS.  If that were the case you should get ORA-01631.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now