Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
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.