How to fix the Oracle error IMP-00089: Fine grain policy “string” not recreated on table/view “string”?

In this post, you’ll learn more about the Oracle ErrorIMP-00089: Fine grain policy “string” not recreated on table/view “string” with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

IMP-00089: Fine grain policy “string” not recreated on table/view “string”

Reason for the Error IMP-00089: Fine grain policy “string” not recreated on table/view “string”

Import user fails to recreate fine grained policies of the table/view being imported. To recreate the policy, the user doing the import needs execute privilege on the package DBMS_RLS for access policies or DBMS_FGA for audit policies.

How to fix the Error IMP-00089: Fine grain policy “string” not recreated on table/view “string” ?

You can fix this error in Oracle by following the below steps

Ask the database administrator to perform the export/import of this table/view.