Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

expdp transportable tablespaces ORA-01403: no data found

Brian.BJun 10 2019 — edited Jun 20 2019

I ran this script before, and today it started throwing error messages.

Has anyone seen this error message? What have you done to resolve it?

Thanks

$ echo "sys/${SYSPWDEV} AS SYSDBA" | expdp parfile=/home/oracle/upgrade_process_expdp.par

Export: Release 11.2.0.4.0 - Production on Mon Jun 10 13:44:58 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Username:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Automatic Storage Management option

Starting "SYS"."SYS_EXPORT_FULL_04":  sys/******** AS SYSDBA parfile=/home/oracle/upgrade_process_expdp.par

Startup took 2 seconds

Estimate in progress using BLOCKS method...

ORA-39123: Data Pump transportable tablespace job aborted

ORA-01403: no data found

ORA-01403: no data found

Job "SYS"."SYS_EXPORT_FULL_04" stopped due to fatal error at Mon Jun 10 13:45:11 2019 elapsed 0 00:00:08

$ cat /home/oracle/upgrade_process_expdp.par

directory=DP_TD_EXPORT

dumpfile=expdp_metadata.dmp

logfile=expdp_metadata.log

transportable=always

full=y

metrics=y

version=12

exclude=table_statistics,index_statistics

exclude=tablespace:" IN ( 'SYSAUX', 'SYSTEM', 'TEMP', 'UNDOTBS1' )"

exclude=schema:" IN ( 'SYS', 'SYSTEM', 'OUTLN' )"

ENCRYPTION_PASSWORD=<pwd>

Comments
Post Details
Added on Jun 10 2019
3 comments
629 views