CODEWITHSUNDEEP
oracle-databasecompressionexadata
nipuro
nipuro

Reputation: 320

Oracle database 12c "compress for query" OPTION

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.

Upvotes: 1

Views: 507

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22447

Define compression at the tablespace level, then when you create your tables in development, don't include any of the storage elements, just let their TABLESPACE characteristics take affect.

Barring that, you're going to have two sets of DDL scripts for source control, one for development, and another for production.

Upvotes: 2

Related Questions