Database Utilities (MOSC)

MOSC Banner

what happens when a datapump import reached resumable timeout state after ORA-39171

edited Jun 24, 2014 3:59PM in Database Utilities (MOSC) 4 commentsAnswered ✓

Hi All,

     I have a data import running using datapump, import job is suspended due to 'ORA-39171: Job is experiencing a resumable wait'  error as below

ORA-39171: Job is experiencing a resumable wait.

ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

This occurred at over the weekend, so no one attended the error until next working day.The tablespace issue ORA-30036 has been addressed,

I know by default resumable timeout is set 7200 for all jobs. what happens after the job reached resumable timeout? will the job continue after the reported error being fixed.

What i found is, the status column in the dictionary tables DBA_RESUMABLE and USER_RESUMABLE is showing as TIMEOUT (not running)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center