Database Software

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!

Compress For OLTP x Row Store Ccompress Advanced

Brad OziApr 3 2017

We migrated 11g database to 12c.

The compressed tables where created with "COMPRESS FOR OLTP" in 12c.

The database is already in production.

I understand that 12c has a new syntax "ROW STORE COMPRESS ADVANCED".

Is there any need in recreating the tables with 12c syntax "ROW STORE COMPRESS ADVANCED"?

If not, are both syntaxes equivalent?

Thanks in advance, Mike.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 1 2017

Added on Apr 3 2017

#advanced-compression, #data-warehousing

0 comments

930 views