POUWIEL|COM

JeroenPouwiel

FGA

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

Comments are closed.

Categories