DataPump Import with Label Security
NoraJul 11 2008 — edited Aug 1 2008Hi,
I'm having some trouble using IMPDP on a table with Label Security.
Basically, I have to move a table with Label Security into another database. So, I did an export of that table using expdp. I created an empty copy of the table and created/applied the Label Security policy to the table in the other database.
When I did an import using IMPDP (using table_exists_action=Replace), it created my label column so that it wasn't hidden; I could see it in the list of columns. It also created some labels that are giving me errors. I also tried doing table_exists_action=APPEND, and I got an error:
ORA-39083: Object type PROCACT_INSTANCE failed to create with error:
ORA-12414: internal LBAC error: Uninitialized session context, please connect again
Error: ORA-01403: no data found
Failing sql is:
BEGIN
lbacsys.lbac_policy_admin.apply_table_policy('POLICYNAME','SCHEMA','TABLE','READ_CONTROL
, INSERT_CONTROL, UPDATE_CONTROL, DELETE_CONTROL, LABEL_DEFAULT, LABEL_UPDATE, CHECK_CONTROL',NULL,N
ULL);COMMIT; END;
Can anybody let me know what steps I should be taking so that the Import runs successfully, creates the labels, and hides the label column?
Thanks much,
Nora