Hi,
I need to export more 1000 tables with clause INCLUDE of expdp but I Know that the maximum length allowed is 4000 bytes including quotation marks, which means that the actual maximum length allowed is 3998 bytes.

Raf Royal wrote:
Hi,
I need to export more 1000 tables with clause INCLUDE of expdp but I Know that the maximum length allowed is 4000 bytes including quotation marks, which means that the actual maximum length allowed is 3998 bytes.

if you have same table on different schema then i suggest before doing export start filtering your database did you ever hear about synonym and view or grant you more than option to avoid duplicate tables on your schema in this case you will export less tables .

Osama_mustafa wrote:
if you have same table on different schema then i suggest before doing export start filtering your database did you ever hear about synonym and view or grant you more than option to avoid duplicate tables on your schema in this case you will export less tables .

I have NO idea what you say here, if in the tables list you include schema1.table_1 and schema2.table_1 are specified AND the exporting user has appropriate privileges, Oracle and expdp are intelligent enough to distinguish between 2 tables in different schema. No idea why synonyms, grants, views should matter, as long as object name is prefixed by schema, you should be ok.

Dear OP,

You want to export 1000 tables, but you dont tell us those 1000 are out of 1100 or 10000. If it is out of 1100 then it is easier to EXCLUDE the ones you don't want, but the best option might be to list owner and table_Name into a table and provide using IN clause rather than providing a long list of tables.

Also you CANNOT provide both INCLUDE and EXCLUDE in one commandline, so I'd recommend you should use a table which contains owner and table names that you like to export. It will make your life easier. As long as exporting user (i.e the one that run expdp) has appropriate privileges, you should have no issues.