ORA-00439: feature not enabled: Advanced Compression
431744Oct 13 2010 — edited Oct 14 2010hi expert,My DB is 11gR2, when I try to create this table...following error occured.
SQL> CREATE TABLE "UDARA_PMS_PR_SUPPORTING_DOC1"
2 (
3 "ID" NUMBER NOT NULL ENABLE,
4 "NAME" VARCHAR2(100 BYTE) NOT NULL ENABLE,
5 "TYPE" VARCHAR2(100 BYTE) NOT NULL ENABLE,
6 "SIZE" NUMBER DEFAULT 0 NOT NULL ENABLE,
7 "CONTENT" BLOB NOT NULL ENABLE,
8 "SEQUENCE_NO" NUMBER DEFAULT 0 NOT NULL ENABLE,
9 "DOC_LEVEL" NUMBER DEFAULT 0 NOT NULL ENABLE,
10 PRIMARY KEY ("ID")
11 )
12 LOB(CONTENT) STORE AS SECUREFILE
13 (TABLESPACE "GENEVATS" DEDUPLICATE)
14 /
CREATE TABLE "UDARA_PMS_PR_SUPPORTING_DOC1"
*
ERROR at line 1:
ORA-00439: feature not enabled: Advanced Compression
Pl help me to solve this issue.
thanks
ashwan