Use FGA to simulate a parallel export in Oracle8:
CREATE or REPLACE FUNCTION NO_ROWS (obj_schema VARCHAR2, obj_name VARCHAR2) RETURN VARCHAR2 IS d_predicate VARCHAR2(2000); BEGIN if sys_context ('USERENV', 'SESSION_USER') = 'auditted_user' THEN d_predicate := '1=2'; else d_predicate := ''; end if; RETURN d_predicate; END NO_ROWS; /
execute dbms_rls.add_policy ('object_owner','object_name','policy_name','function_owner','function_name'); execute dbms_rls.drop_policy ('object_owner','object_name','policy_name');
Add a policy for each object/table you want to exclude in the main/schema export. (“owner=(ownone, owntwo, own3ee)”)
Create a separate export session for each individual object/table. (“tables=(ownone.tableone)”)