PARTITION part_02 values LESS THAN (TO_DATE('0','DD-MON-YYYY')) PARTITION part_01 values LESS THAN (TO_DATE('0','DD-MON-YYYY')), The ALTER TABLE syntax allows you to transform existing range partitioned table to the interval partition as: ALTER TABLE table_name SET INTERVAL ( … ) įor additional information about the ALTER TABLE interval partitioning syntax, see Database Compatibility for Oracle® Developer’s Guide Section 10.3.9.Ĭonsider a partitioned table containing sales data that is divided into monthly partitions according to sale date as follows: CREATE TABLE sales ( PARTITION BY RANGE( … ) INTERVAL (expression)įor the complete creation of the interval range partitioning syntax, see the EDB Postgres Advance Server User Guide Database Compatibility for Oracle® Developer’s Guide Section 10.3.1. Here is the interval partitioning syntax for the CREATE TABLE command: CREATE TABLE table_name ( … ) The EPAS partitioning syntax has been extended to include an INTERVAL clause, which specifies the range size for a new partition to be created. Interval partitioning is an extension to range partitioning to handle situations where the specific range will be never-ending but range partitions need to be created whenever required-for example, a table partitioned on a date range where the data to be loaded progresses uniformly in a timely manner and the required partition for that date range needs to be created in time order. Interval partitioning allows a database to automatically create a new partition when newly inserted data exceeds the range of an existing partition. This article introduces the interval partitioning feature for EDB Postgres Advanced Server and demonstrates how it can be used to automatically create new table partitions whenever required.ĮDB Postgres Advanced Server v12 (EPAS) introduces the Interval Partitioning feature.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |