My Oracle Support Banner

DataPump Export (EXPDP) Fails With ORA-01647 When Using TRANSPORTABLE=ALWAYS and FULL=Y (Doc ID 2318790.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

While performing an export job using the command:

expdp system directory=tts_dump dumpfile=tts_scstat.dmp logfile=tts_dump_log:tts_scstat.log full=y transportable=always version=12

the following errors are raised:

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [PLUGTS_BLK]
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_AW_EXP".SCHEMA_CALLOUT(:1,0,1,'12.00.00.00.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 1749
ORA-01647: tablespace 'SDD' is read-only, cannot allocate space in it

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001

The error message is changed after the installation of a fix for Bug 17402461:

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [PLUGTS_BLK]
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_AW_EXP".SCHEMA_CALLOUT(:1,0,1,'12.00.00.00.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 1749
ORA-00372: file 48 cannot be modified at this time
ORA-01110: data file 48: '+DATA1/scstat/datafile/sdd.315.830696487'

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001


None of the following options have helped to obtain a successful job execution:

- Increase the tablespace's size;
- Crosscheck for any TTS violations. Select from transport_set_violations doesn't return violations after the execution of dbms_tts.transport_set_check.
- Apply Patch 17402461.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.