DBMS_REDEFINITION and invisible column
Hi All,
I would like to check if DBMS_REDEFINITON and invisible column can work together, i.e., I receive the following error while updating column visibility.
ORA-54042: Invisible column is not supported on this type of table.
54042. 0000 - "Invisible column is not supported on this type of table."
*Cause: An attempt was made to create or alter the visibility of a column
on an unsupported table type. Invisible columns are only supported
for heap and index-organized tables (IOT).
*Action: These columns are not supported, change the DDL.
I wasn't able to find the support flag(s) in the restriction section of the documentation.