Forum Stats

  • 3,839,643 Users
  • 2,262,518 Discussions


Compress For OLTP x Row Store Ccompress Advanced

Brad Ozi
Brad Ozi Member Posts: 11 Blue Ribbon

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.

This discussion has been closed.