Environment
Oracle 11.2.0.4 EE on Solaris 10
I am trying to export just a few specific objects and getting some errors. I had another thread open but my approach there was too broad so I've narrowed it down.
Here is my parameter file:
userid=stage1/<password>
directory=data_pump_dir
dumpfile=expdp_stage1_lnc2.dmp
logfile=expdp_stage1_lnc2.log
include=PROCEDURE:"= ('SSP_UPDATE_TABLE_STATS')"
# include=SEQUENCE:"in ('CURR_IDENTITY_SUMMARY_SEQ','CURR_ENTITY_ALERTS_SEQ','ENTITY_ALERT_CONFIG_SEQ','REPORT_APS_PROCESS_STATUS_SEQ')"
reuse_dumpfiles=yes
I've tried this also just with one or the other object type but get the same results.
Here is the log file:
Export: Release 11.2.0.4.0 - Production on Fri Jun 17 13:32:17 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning option
FLASHBACK automatically enabled to preserve database integrity.
Starting "STAGE1"."SYS_EXPORT_SCHEMA_01": stage1/******** parfile=expdp_stage1_lnc2.par
Estimate in progress using BLOCKS method...
Total estimation using BLOCKS method: 0 KB
ORA-39168: Object path PROCEDURE was not found.
ORA-31655: no data or metadata objects selected for job
Job "STAGE1"."SYS_EXPORT_SCHEMA_01" completed with 2 error(s) at Fri Jun 17 13:32:24 2016 elapsed 0 00:00:07
I've searched for that error message but can't seem to find the right syntax to make it happen.
Any help is appreciated!!
-gary