DBMS_Redefinition
Have been running DBMS_Redefinition using the rowid method. the
documentation states that I should be able to delete a hidden column
called M_ROW$$. I don't have such a column. However, each table has a
hidden column as below
select table_name,column_name from user_tab_cols where hidden_column = 'YES'
CLAIM_STATUS_HIST_PRE_ARCHIV SYS_C00006_10070812:37:32$
CLAIMS_PRE_ARCHIVE SYS_C00048_10070812:37:34$
VALIDATION_ERRORS_PRE_ARCH SYS_C00009_10070812:37:34$
CLAIM_TREATMENTS_PRE_ARCHIVE SYS_C00010_10070812:37:38$
IOS_ADJUSTMENTS_PRE_ARCH SYS_C00014_10070812:37:38$
select table_name,column_name from user_tab_cols where hidden_column = 'YES'
CLAIM_STATUS_HIST_PRE_ARCHIV SYS_C00006_10070812:37:32$
CLAIMS_PRE_ARCHIVE SYS_C00048_10070812:37:34$
VALIDATION_ERRORS_PRE_ARCH SYS_C00009_10070812:37:34$
CLAIM_TREATMENTS_PRE_ARCHIVE SYS_C00010_10070812:37:38$
IOS_ADJUSTMENTS_PRE_ARCH SYS_C00014_10070812:37:38$
0