PARTITION - Getting ORA-14308
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