Forum Stats

  • 3,851,953 Users
  • 2,264,054 Discussions
  • 7,904,915 Comments

Discussions

Compress for OLTP and ORA-14464

Heidi Weber
Heidi Weber Member Posts: 86
edited Nov 3, 2010 1:14AM in Advanced Compression
Hello,

i have a Oracle-DB 11.2 and want to use Advanced Compression.

I want to create a table:

CREATE TABLE TD_GE_1990
( "name_id" NUMBER(1,0),
"name_txt" VARCHAR2(100 BYTE)
) COMPRESS FOR OLTP;


But i get:
SQL-Fehler: ORA-14464: Kompressionstyp nicht angegeben


The "compatible"-Parameter is set to 11.1:
SELECT value
FROM gv$parameter
WHERE name LIKE '%compatible%';

11.1.0.0.0


Do i have to change something in the database?
Best regards
Heidi

Answers

  • 764435
    764435 Member Posts: 28
    This post is related to following thread and got resolved by changing compatible parameter to 11.2.0:
    http://translate.google.co.in/translate?hl=en&sl=ko&u=http://kr.forums.oracle.com/forums/thread.jspa%3FthreadID%3D1594232%26tstart%3D345&ei=_u7QTKCwKIOfcbqxqdgL&sa=X&oi=translate&ct=result&resnum=2&ved=0CCMQ7gEwAQ&prev=/search%3Fq%3DORA-14464:%2BKompressionstyp%2Bnicht%2Bangegeben%26hl%3Den%26client%3Dsafari%26rls%3Den
This discussion has been closed.