Database DataWarehousing (MOSC)

MOSC Banner

Receiving Error when converting a table to use partitioning

edited Feb 29, 2012 3:38AM in Database DataWarehousing (MOSC) 4 commentsAnswered ✓
I am getting the following errors when I try converting a table to use partitioning. I converted other tables successfully in the same schema but the following is not cooperating. Any input is greatly appreciated. Original DDL for the following interim table is the same except the I omitted the index constraint and added the partitioning clause. What am I doing wrong this time? :-)

CREATE TABLE SOADEV_SOAINFRA.MEDIATOR_AUDIT_DOCUMENT_PART
   (    ID VARCHAR2(100) NOT NULL ENABLE,
        AUDIT_ID VARCHAR2(100) NOT NULL ENABLE,
        NAME VARCHAR2(1000),
        DOCUMENT BLOB,
        TYPE VARCHAR2(100),
        PAYLOAD_KEY VARCHAR2(200),
        INSTANCE_ID VARCHAR2(100),
        CASE_ID VARCHAR2(100),
        MI_PARTITION_DATE TIMESTAMP (6)

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