export utility

[TP Babu]

Hi All,

We are doing logical backup using export utility .Is any option to restrict the export on particular tables.

That is we have 120 tables in which we have to export only 100 tables.Is anyother way to export those tables other than the option tables=(t1,t2)

Regards,
sivam

[jmodic]

Yes, there is:

Apply an appropriate security policy (package SYS.DBMS_RLS) to those 20 tables you don't want to export and apply the appropriate security context (for example, add the predicate "WHERE 1=2" for those tables) to the exporting user. That way, the metadata for those 20 tables will still be exported, but their actual data won't.