RE: ** export excluding some tables

Joshi

>I know we can specify tables but is there a way to exclude certain
>tables. Thanks for your help.

In 10g, if you use Data Pump, this is not a problem. See parameter EXCLUDE.

Otherwise you could create a policy that hides all rows for the tables you don't want to export. For example:

CONNECT SYSTEM CREATE OR REPLACE FUNCTION restrict(schema IN VARCHAR2, tab IN VARCHAR2) RETURN VARCHAR2 AS BEGIN
  RETURN '1=0';
END restrict;
/

EXECUTE dbms_rls.add_policy(<owner>,<table>,'policy','system','restrict');

Notice that this only works if the user doing the exports has no EXEMPT ACCESS POLICY privilege.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l