Hi all
I've been trying to export certain tables and partitions of a schema including all packages of the schema.
I'm using a parameter file which contains among others the TABLES and INCLUDE parameters.
My understanding was, that I can define all tables and partitions I want to export in TABLES and then add package to INCLUDE.
Unfortunately expdp keeps claiming: ORA-39168: Object path PACKAGE was not found.
I've tried using SCHEMA_EXPORT/PACKAGE as well without success.
Since I could find PACKAGE in the SCHEMA_EXPORT_OBJECTS view I assume the object type must be valid I'm missing something here.
My parameter file:
JOB_NAME=job name
DIRECTORY=directory
LOGFILE=logfile.log
DUMPFILE=dumpfile_%U.dmp
COMPRESSION=ALL -- yes, I can use Advanced Compression
FLASHBACK_TIME=SYSTIMESTAMP
PARALLEL=10
CLUSTER=N
INCLUDE=PACKAGE,TABLE -- I've also tried separating PACKAGE and TABLE in two INCLUDE lines and I've also tried SCHEMA_EXPORT/PACKAGE
TABLES=Some tables and partitions, this works
Query of SCHEMA_EXPORT_OBJECTS table, OBJECT_PATH PACKAGE seems to be exactly what I need
SELECT OBJECT_PATH, COMMENTS FROM SCHEMA_EXPORT_OBJECTS where object_path = 'PACKAGE' order by 1;
OBJECT_PATH COMMENTS
-------------------------------------------------- --------------------------------------------------
PACKAGE Packages (both specification and body) and their d
ependent grants and audits
Thanks in advance
David