Storage Options for Tables

BNitsche

Hi,

we are currently use Source Control for Oracle. When i create a table in the database and make a checkin in Git the table SQL Script look like this

CREATE TABLE dwhsl_core.test_redgate (

  column1 VARCHAR2(20 BYTE) NOT NULL

) COMPRESS

PCTFREE 0 INITRANS 1 LOGGING

STORAGE(FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)

TABLESPACE dwhsl_core;

When i make a checkin in Flyway to Git the Table lokks like this:

CREATE TABLE dwhsl_core.test_redgate (

  column1 VARCHAR2(20 BYTE) NOT NULL

);

The Storage Options are missing. Can i configure Flyway to include this storage optins?

Best Regards
Bernd

DanC

Hi @BNitsche

Absolutely you can, you just need to configure the Oracle comparison options for Flyway Desktop to use!

The following documentation should help you with this:

https://documentation.red-gate.com/sco/setting-project-options-148079194.html
Further down the page you'll find the storage options: 

Include all storage options
Includes all storage properties (physical properties) on tables and indexes when comparing and deploying schemas.

https://documentation.red-gate.com/fd/oracle-comparison-options-138347106.html

BNitsche

Hi,

thanks that helped, i modified the json file and now the storga options are included

Kind Regards
Bernd