Database DataWarehousing (MOSC)

MOSC Banner

DBMS_Redefinition

edited Jul 11, 2010 11:50PM in Database DataWarehousing (MOSC) 4 commentsAnswered
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$
 

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