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)”)