Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DataPump Import with Label Security

NoraJul 11 2008 — edited Aug 1 2008
Hi,
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 29 2008
Added on Jul 11 2008
4 comments
1,929 views