Hi,
I am using lb generate-schema -split to extract all changes related to a schema in a source oracle DB. and before running this command I set DDL off for STORAGE, PARTITIONING, SEGMENT_ATTRIBUTES, TABLESPACE, EMIT_SCHEMA and SIZE_BYTE_KEYWORD.
after export complete i find that indexes xml file contains all information related storage and all other INDEX_ATTRIBUTES.
the problem is when i try to update destination schema i receive error “ORA-02203: INITIAL storage options not allowed”.
I notices when I use command LB GEO -OBN INDEX_NAME -OBT INDEX, xml generate without storage attributes and the update complete successfully.
is there any option to avoid storage and index attribute in generate schema command?
-
Learn
-
Resources
-
Free Tools
OSS Risk Scanner Database DevOps Risk AssessmentCheat Sheets
Snowflake + Liquibase Databricks + Liquibase -
eBooks
6 Liquibase Community Risks & How to Avoid Guide: SOC 2 Compliance at the Database Layer Guide: Quantify the Value of Liquibase Secure -
Comparison Guides
Liquibase vs. Flyway Liquibase vs. Bytebase Liquibase Community vs Liquibase Secure
-
- Quickstart
- Get Started
- Documentation
- University
-
Resources
- Connect
- Contribute
- Join
- Blog