Thanks a lot Chris!
A reader, December 14, 2016 - 4:21 am UTC
Parallel execution of dbms_redefinition
A reader, April 03, 2017 - 9:58 am UTC
Hi,
Is there any way , we can do redefinition in parallel like ALTER session kind of setting?
Error
A reader, April 04, 2017 - 8:58 am UTC
Could you please help to get rid of below error -
ORA-42039: cannot online redefine table "TEST_SCHEMA"."TB_TES_REDIFE" with FGA or RLS enabled
ORA-06512: at "SYS.DBMS_REDEFINITION", line 143
ORA-06512: at "SYS.DBMS_REDEFINITION", line 1635
ORA-06512: at line 1
42039. 00000 - "cannot online redefine table \"%s\".\"%s\" with FGA enabled"
*Cause: An attempt was made to redefine a table with Fine Grained Auditing
(FGA) or Row Level Security (RLS) enabled.
*Action: Do not attempt to online redefine a table with Fine Grained Auditing
(FGA) or Row Level Security (RLS) enabled.
April 04, 2017 - 12:31 pm UTC
Um.... isn't this sort of obvious:
"Action: Do not attempt to online redefine a table with Fine Grained Auditing
(FGA) or Row Level Security (RLS) enabled. "
You'd need to drop the policy in order to do dbms_redefinition
More deatils
A reader, April 04, 2017 - 12:36 pm UTC
Hi Connor,
Can you explain what these policies (Fine Grained Auditing
(FGA) or Row Level Security (RLS)) are?
Is it recommended to drop these policies?
How to do it and redefine the table with such policies?
I tried searching on these, but didn't get useful info.