SQL Language (MOSC)

MOSC Banner

DBMS_REDEFINITION and invisible column

edited Jul 17, 2018 5:11AM in SQL Language (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center