Oracle Faq

The exclude and include parameters availbale with expdp,impdp can be used as metadata filters so that one can specify any objects like tables,indexes,triggers, procedure to be excluded or included during export or import operation

syntax:
EXCLUDE=[object_type]:[name_clause],[object_type]:[name_clause]

INCLUDE=[object_type]:[name_clause],[object_type]:[name_clause]
examples:
expdp <other_parameters> SCHEMAS=scott EXCLUDE=SEQUENCE,TABLE:”IN (’EMP’,’DEPT’)”;
impdp <other_parameters> SCHEMAS=scott INCLUDE=PACKAGE,FUNCTION, PROCEDURE,TABLE:”=’EMP’”
The name_clause is a SQL expression that is used as a […]

Hi,
As we know with oracle 10g we export datapump utility ofr taking the export and impdp for import.Now expdp as well as impdp requires directory to be created so that all the exports taken are stores in that directory and all the import dumps which are read by impdp will read from that directory.
So, before […]