--- title: Partition Clause and table storage (Model Object) description: Six Oracle model-object properties set how a generated table is stored and how its loader gathers statistics. --- [Skip to content](https://knowledge.bigenius-x.com/partition-clause-and-table-storage-model-object#main-content) [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal?hsLang=en) [![TRI\_Logo\_biGENIUS\_2020\_RGB\_s](https://knowledge.bigenius-x.com/hs-fs/hubfs/Marketing/TRI_Logo_biGENIUS_2020_RGB_s.png?width=150&height=42&name=TRI_Logo_biGENIUS_2020_RGB_s.png)](https://www.bigenius-x.com/) Open main navigation Close main navigation - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new) - [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal) How can we help you? - There are no suggestions because the search field is empty. 1. [biGENIUS-X Knowledge Base](https://knowledge.bigenius-x.com/?hsLang=en) 2. [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en) 3. [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties) # Partition Clause and table storage (Model Object) **Applies to** Platform: Oracle Six Oracle model-object properties set how a generated table is stored and how its loader gathers statistics. They are Partition Clause, Table Compression, Tablespace Table, Tablespace Index, Create Table Statistics and Parallel Degree of Statistics Calculation. Set them when a table needs partitioning, compression, its own tablespaces or other statistics settings; the CREATE TABLE statement and the loader then carry them. ### Supported objects Set the properties in [Edit Model Object](https://knowledge.bigenius-x.com/edit-a-model-object?hsLang=en), Technology group. They are offered on these model object types: - Stage: Stage - Data Store: Store Entity, Store Composite - Data Vault: every Raw Vault and Business Vault type, including PIT, RawVault Composite, BusinessVault Composite and Vault Out - Data Mart: Mart Composite, Mart Dimension, Mart Fact, Mart Out Business Driving Key Link offers all of them except Partition Clause and Table Compression. ### Properties #### Partition Clause Partition Clause (`OraclePartitionClause`) is a complete Oracle partition clause, empty by default. The text is added to the CREATE TABLE statement after the column list and the storage options, for example `PARTITION BY HASH (HUB_HK) PARTITIONS 4`. A model object with Implementation Type `Virtual` has no table, so the clause is ignored there. See [Setting ignored for a Virtual model object (Business Rule)](https://knowledge.bigenius-x.com/setting-ignored-for-a-virtual-model-object-business-rule?hsLang=en). Since Generator 2.4.1, bitmap indexes on a table with a Partition Clause are created as local indexes. Local custom indexes are described in [Add an Index](https://knowledge.bigenius-x.com/add-an-index?hsLang=en). #### Table Compression Table Compression (`TableCompression`) adds an Oracle compression clause to the CREATE TABLE statement, written as the value reads. The values are: - `None` (default): no clause. - `COMPRESS`, `ROW STORE COMPRESS ADVANCED` - `COMPRESS FOR QUERY LOW`, `COMPRESS FOR QUERY HIGH`, `COMPRESS FOR ARCHIVE LOW`, `COMPRESS FOR ARCHIVE HIGH` - `COLUMN STORE COMPRESS FOR QUERY LOW`, `COLUMN STORE COMPRESS FOR QUERY HIGH`, `COLUMN STORE COMPRESS FOR ARCHIVE LOW`, `COLUMN STORE COMPRESS FOR ARCHIVE HIGH` #### Tablespace Table Tablespace Table (`TableTablespace`) adds `TABLESPACE ` to the CREATE TABLE statement. Empty (default) creates the table in the default tablespace of the layer user. The layer user needs quota on the tablespace you name. #### Tablespace Index Tablespace Index (`IndexTablespace`) adds `TABLESPACE ` to the indexes of the table: the primary-key and unique-key indexes and the default and custom indexes. Empty (default) uses the default tablespace of the layer user. Without quota on the tablespace, the deployment of the table fails with `ORA-01950`. #### Create Table Statistics Create Table Statistics (`CreateTableStatistics`) is a Boolean, `true` by default. With `true` the loader gathers table statistics after each load with `dbms_stats.gather_table_stats`. With `false` the loader gathers none, and the table keeps the statistics Oracle collected otherwise, for example at deployment. #### Parallel Degree of Statistics Calculation Parallel Degree of Statistics Calculation (`StatisticParallelDegree`) is a whole number from 1, empty by default. The loader sets it as the table preference `DEGREE` before it gathers statistics, so it applies only with Create Table Statistics `true`. Other values stop the generation with the validation error `Model object has non numeric degree of parallelism for calculation of statistics configured` or `Model object has degree of parallelism smaller than 1 for calculation of statistics configured`. ### Example A Hub has Partition Clause `PARTITION BY HASH (HUB_HK) PARTITIONS 4`, Table Compression `COMPRESS`, Tablespace Table `USERS`, Tablespace Index `USERS_IDX` and Parallel Degree of Statistics Calculation `4`. The Raw Vault script creates its table like this, with `` for the Raw Vault schema: ``` CREATE TABLE .RDV_HUB_LOAD_CUSTOMER_HUB ( BG_LOADTIMESTAMP TIMESTAMP NOT NULL ,HUB_HK RAW(20) NOT NULL ,BG_SOURCESYSTEM VARCHAR2(255) ,CUSTOMER_ID NUMBER NOT NULL ) TABLESPACE USERS COMPRESS PARTITION BY HASH (HUB_HK) PARTITIONS 4 ; ``` Its primary-key and unique-key indexes are created with `TABLESPACE USERS_IDX`. The loader ends with: ``` dbms_stats.set_table_prefs(ownname => '', tabname => 'RDV_HUB_LOAD_CUSTOMER_HUB', pname => 'DEGREE', pvalue => '4'); dbms_stats.gather_table_stats(ownname => '', tabname => 'RDV_HUB_LOAD_CUSTOMER_HUB', no_invalidate => FALSE); ``` After deployment and one load, the table has four hash partitions in `USERS` with basic compression, and both indexes are in `USERS_IDX`. ### Changing the values on deployed tables Partition Clause, Table Compression and the tablespaces take effect when the table is created. With the default [Deployment Options](https://knowledge.bigenius-x.com/deployment-options-project?hsLang=en), the next deployment recreates the table empty with the new settings. Without Generate Drop Table Statements, an existing table keeps its storage. The statistics properties change only the loader and take effect with the next deployment. ### Related articles - Reference: [Deployment Options (Project)](https://knowledge.bigenius-x.com/deployment-options-project?hsLang=en), [Hash Group Size (Model Object)](https://knowledge.bigenius-x.com/hash-group-size-model-object?hsLang=en), [Setting ignored for a Virtual model object (Business Rule)](https://knowledge.bigenius-x.com/setting-ignored-for-a-virtual-model-object-business-rule?hsLang=en) - See also: [Add an Index](https://knowledge.bigenius-x.com/add-an-index?hsLang=en), [Oracle - Target environment](https://knowledge.bigenius-x.com/oracle-target-environment?hsLang=en), [Oracle - Deployment](https://knowledge.bigenius-x.com/oracle-deployment?hsLang=en), [Generators Release - 2.4.1](https://knowledge.bigenius-x.com/generators-release-2.4.1?hsLang=en) - [Getting started](https://knowledge.bigenius-x.com/getting-started?hsLang=en#main-content) - [Guidelines](https://knowledge.bigenius-x.com/getting-started?hsLang=en#guidelines) - [Start working](https://knowledge.bigenius-x.com/getting-started?hsLang=en#start-working) - [Account](https://knowledge.bigenius-x.com/getting-started?hsLang=en#account) - [General overview](https://knowledge.bigenius-x.com/general-overview?hsLang=en) - [Artificial Intelligence](https://knowledge.bigenius-x.com/artificial-intelligence?hsLang=en) - [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en#main-content) - [Administration](https://knowledge.bigenius-x.com/application-modules?hsLang=en#administration) - [Solutions](https://knowledge.bigenius-x.com/application-modules?hsLang=en#solutions) - [Global Features](https://knowledge.bigenius-x.com/application-modules?hsLang=en#global-features) - [Projects](https://knowledge.bigenius-x.com/application-modules?hsLang=en#projects) - [Branches](https://knowledge.bigenius-x.com/application-modules?hsLang=en#branches) - [Data Connections](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-connections) - [Dataflow Modeling - Overview](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-overview) - [Dataflow Modeling - Wizard Steps](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-wizard-steps) - [Dataflow Modeling - Terms](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-terms) - [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping) - [Dataflow Modeling - Relationships](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-relationships) - [Dataflow Modeling - Data Quality](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-data-quality) - [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-indexes) - [Relationship Modeling](https://knowledge.bigenius-x.com/application-modules?hsLang=en#relationship-modeling) - [Generate Artifacts](https://knowledge.bigenius-x.com/application-modules?hsLang=en#generate-artifacts) - [Project Settings](https://knowledge.bigenius-x.com/application-modules?hsLang=en#project-settings) - [Data Marketplace](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-marketplace) - [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en#main-content) - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse) - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse) - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks) - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake) - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server) - [Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#artifacts) - [Replace Placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders) - [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment) - [Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment) - [Deployment with an Azuze DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azuze-devops-pipeline) - [Delta Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#delta-deployment) - [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment) - [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control) - [Load data with Apache Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow) - [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type) - [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties) - [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms) - [Discovery application](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#main-content) - [Discovery configurations](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#discovery-configurations) - [Best practices](https://knowledge.bigenius-x.com/best-practices?hsLang=en#main-content) - [Modeling Approaches](https://knowledge.bigenius-x.com/best-practices?hsLang=en#modeling-approaches) - [Use Cases](https://knowledge.bigenius-x.com/best-practices?hsLang=en#use-cases) - [Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules) - [Data Quality Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#data-quality-rules) - [FAQs](https://knowledge.bigenius-x.com/faqs?hsLang=en) - [Product Release Notes](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#main-content) - [SaaS Application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#saas-application) - [Discovery application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#discovery-application) - [Generators](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#generators) - [Legal Documents](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#main-content) - [Current legal docs](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#current-legal-docs) - [Software Product and Limits](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#software-product-and-limits) - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) - [Customer Portal](https://knowledge.bigenius-x.com/customer-portal) - [Sign in](https://knowledge.bigenius-x.com/_hcms/mem/login) [![biGENIUS logo](https://knowledge.bigenius-x.com/hubfs/TRI_Logo_biGENIUS_2020_RGB-1.svg "biGENIUS logo")](https://www.bigenius-x.com) All rights reserved © 2025, biGENIUS AG