DBMS_REDEFINITION.start_redef_table fails
11.2.0.2
Hi,
Im trying to redefine a table online:
This is the target table:
CREATE TABLE NEOTEST.TESTPART
(
DTOTALELIGIBLE FLOAT(126) DEFAULT 0 NOT NULL,
DTOTALPURCHASEAMOUNT FLOAT(126) DEFAULT 0 NOT NULL,
ICOUNTRYEARNRULEID NUMBER(10) DEFAULT 0 NOT NULL,
IRECIPIENTID NUMBER(10) DEFAULT 0 NOT NULL,
IREGISTERNO NUMBER(10) DEFAULT 0 NOT NULL,
IREGISTERRECEIPTNO NUMBER(10) DEFAULT 0 NOT NULL,
ISTORENO NUMBER(10) DEFAULT 0 NOT NULL,
ITRANSACTIONSEQNO NUMBER(10) DEFAULT 0 NOT NULL,
TSCREATED TIMESTAMP(6) WITH TIME ZONE,
TSLASTMODIFIED TIMESTAMP(6) WITH TIME ZONE,
TSPOINTSCREATION TIMESTAMP(6) WITH TIME ZONE,
TSTRANSACTION TIMESTAMP(6) WITH TIME ZONE,
TSTRANSACTIONDATE DATE GENERATED ALWAYS AS (cast(TSTRANSACTION as date)) VIRTUAL,
DPAIDBYHIGH FLOAT(126) DEFAULT 0 NOT NULL,
DPAIDBYLOW FLOAT(126) DEFAULT 0 NOT NULL,
DPAIDBYMED FLOAT(126) DEFAULT 0 NOT NULL,