What are the challenges you face when working across database platforms? Take the survey
Options

Storage Options for Tables

BNitscheBNitsche Posts: 7 New member
edited January 18, 2023 11:05AM in Flyway Desktop
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



Tagged:

Best Answer

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file