Oracle compress with option FOR OLTP

[Towes71]

Hi

I'm trying out compression on oracle but for unknown reason i cant use option "for oltp" (se below)

any ideas ?

SQL> create table ct(x int) compr for oltp

2 ;

create table ct(x int) compr for oltp

*

ERROR at line 1:

ORA-00922: missing or invalid option

SQL> create table ct(x int) compress;

Table created.

SQL> drop table ct

2 ;

Table dropped.

[Towes71]

Hi

ti was a typo the first sql, but still had the same issue, but the solution was to change the compatible parameter to 11.2

thanx

Tord

[Former Member]

There is no compr keyword, it's compress

SQL> create table ct(x int) compr for oltp;
create table ct(x int) compr for oltp
                       *
ERROR at line 1:
ORA-00922: missing or invalid option


SQL> create table ct(x int) compress for oltp;

Table created.

Cheers Michael

[markus_doehr2]

Was the underlying tablespaces created with "compress"?

Markus