Choosing the livereorg option give the following error message:
"SCHEMA.TABLE LiveReorg does not support columns whose names match a column type in the same table."
As the error message states there is a column in the table whose name is the same as a type.
See below example:
SQL> desc example.test_table;
Name Null? Type
----------------------------------------- -------- ----------------------------
K1ID NOT NULL RAW(16)
K2ID NOT NULL RAW(16)
K3C4 NOT NULL VARCHAR2(4)
F1ID RAW(16)
F2I4 NOT NULL NUMBER(10)
F3I4 NOT NULL NUMBER(10)
CSTR NOT NULL VARCHAR2(255)
CLOB CLOB
SBLOB BLOB
SCLOB CLOB
SQL>
Here the column CLOB has the same name as the type "CLOB"
Use either the "Redefinition" option or "Standard Reorganization".
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy