I have a development server on a simple server with oracle 12c and our production server is on Oracle Exadata.
On some of the tables we use COMPRESS FOR QUERY option. My problem is every time we create a table we need to remove this option(from DDL) for development and put it when we deploy changes on production.
Is there any option at database level to use the option on development server also, even if the server is not exadata(something like skiping it) ?
Thank you.