SQL Language (MOSC)

MOSC Banner

PARTITION - Getting ORA-14308

edited May 24, 2014 9:39AM in SQL Language (MOSC) 2 commentsAnswered ✓

Hi All,

Trying to create a Partition Table, but getting this error  - ORA-14308

Oracle Database 11.2.0.4 (64-bit)

Windows 64bit

SQL> CREATE TABLE P_ITEM_PROPERTY

(

  ITEM_ID          CHAR(32),

  ITEM_TYPE        VARCHAR2(14),

  START_DATETIME   DATE,

  END_DATETIME     DATE                         DEFAULT TO_DATE('01-JAN-9000','DD-MON-YYYY'),

  PROPERTY_TYPE    VARCHAR2(15),

  PROPERTY_VALUE   NUMBER,

  PROPERTY_DATE    DATE,

  PROPERTY_STRING  NVARCHAR2(200),

  LAST_UPDT_USER   NVARCHAR2(100),

  LAST_UPDT_DATE   DATE                         DEFAULT SYSDATE,

  VERSION          CHAR(32)                     DEFAULT SYS_GUID(),

  DB_ID            CHAR(32),

  ROW_ID           CHAR(32)                     DEFAULT SYS_GUID(),

  STATUS           VARCHAR2(10),

  REV_GRP_ID       CHAR(32),

  UPDATE_SOURCE    CHAR(1)                      DEFAULT 'X',

  CREATE_SOURCE    CHAR(1)                      DEFAULT 'X'

)

NOCOMPRESS

TABLESPACE USAVM_DATA

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