Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Advanced compression

767351May 4 2010 — edited May 4 2010

Hi to all,

I am trying to create the table in advanced compression (compression for all operations) by using the following syntax

create table adv_student1 COMPRESS FOR ALL OPERATIONS
(sno number(7),
sname varchar2(10),
branch varchar2(10),
dob date,
add1 varchar2(5),
add2 varchar2(10),
country varchar2(10
));

create table adv_student1 COMPRESS FOR ALL OPERATIONS(sno number(7),sname varchar2(10),branch varchar2(10),dob date,add1 varchar2(5),add2 varchar2(10),country varchar2(10));
*
ERROR at line 1:
ORA-00922: missing or invalid option

Could you help me

Thanks & Regards,
Tangella

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2010

Added on May 4 2010

#11g, #general-database-discussions

6 comments

890 views