what is the easiest way to export and deploy to another Oracle only the views, triggers, procedures, functions, packages of a schema on 10gR2?
I tried expdp, but for functions and packages it gives an error as below;
$ expdp sh/sh DUMPFILE=sh_partial.dmp DIRECTORY=ext_tab_dir SCHEMAS=sh INCLUDE=PROCEDURE,VIEW,TRIGGER,FUNCTION,PACKAGE
Export: Release 10.2.0.3.0 - Production on Monday, 24 December, 2007 16:51:42
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SH"."SYS_EXPORT_SCHEMA_01": sh/******** DUMPFILE=sh_partial.dmp DIRECTORY=ext_tab_dir SCHEMAS=sh INCLUDE=PROCEDURE,VIEW,TRIGGER,FUNCTION,PACKAGE
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
ORA-39168: Object path FUNCTION was not found.
ORA-39168: Object path PACKAGE was not found.
Master table "SH"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SH.SYS_EXPORT_SCHEMA_01 is:
/tmp/exp/sh_partial.dmp
Job "SH"."SYS_EXPORT_SCHEMA_01" completed with 2 error(s) at 16:51:47
where as they are listed under SCHEMA_EXPORT_OBJECTS;
SQL> select a.OBJECT_PATH from SCHEMA_EXPORT_OBJECTS a where a.OBJECT_PATH like 'SCHEMA_EXPORT%';
OBJECT_PATH
-----------------------
SCHEMA_EXPORT/ASSOCIATION
..
SCHEMA_EXPORT/FUNCTION
..
SCHEMA_EXPORT/MATERIALIZED_VIEW
SCHEMA_EXPORT/OPERATOR
SCHEMA_EXPORT/PACKAGE
..
66 rows selected
Thank you.