Database DataWarehousing (MOSC)

MOSC Banner

DBMS_REDEFINITION.start_redef_table fails

edited Jun 24, 2013 10:10PM in Database DataWarehousing (MOSC) 2 commentsAnswered ✓

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,

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