HowTo set ROWDEPENDENCIES for all tables of a schema
Hallo,
I am searching for the "best" way to set ROWDEPENDENCIES for all tables of a schema. I know that I have to recreate the objects. I tried the DBMS_REDEFINITION Package but before using it, I have to manually create a interim table with ROWDEPENDENCIES set.
So I need a way to extract the DDL of all tables in a schema that do not have rowdependencies set, modify the ddl automaticly and create the new object. It doesn't matter if I have to use DBMS_REDEFINITION afterwards or export and then import the table data via IMP/ EXP or datapump.
I am searching for the "best" way to set ROWDEPENDENCIES for all tables of a schema. I know that I have to recreate the objects. I tried the DBMS_REDEFINITION Package but before using it, I have to manually create a interim table with ROWDEPENDENCIES set.
So I need a way to extract the DDL of all tables in a schema that do not have rowdependencies set, modify the ddl automaticly and create the new object. It doesn't matter if I have to use DBMS_REDEFINITION afterwards or export and then import the table data via IMP/ EXP or datapump.
0