Database Administration (MOSC)

MOSC Banner

convert range partition table to interval partition for automatic partitioning

edited Jun 12, 2018 5:03AM in Database Administration (MOSC) 3 commentsAnswered

This is the DDL of the existing range partition table, where the table is partitioned by column LAST_UPDT_TS and the partitions are manually created every month.

Trying to convert this to interval partitioned table so that the partitions will be created automatically

CREATE TABLE ODS.SALES_TRANSACTION_TAX

(

  CHAIN_NBR              NUMBER(10)             NOT NULL,

  STORE_NBR              NUMBER(10)             NOT NULL,

  REGISTER_NBR           NUMBER(10)             NOT NULL,

  TRANSACTION_NBR        NUMBER(10)             NOT NULL,

  TRANSACTION_DT         DATE                   NOT NULL,

  TRANSACTION_TM         VARCHAR2(10 BYTE)      NOT NULL,

  TAX_LINE_NBR           NUMBER(10)             NOT NULL,

  TAX_LEVEL_NBR          NUMBER(10)             NOT NULL,

  TAX_CATEGORY_NBR       NUMBER(10)             NOT NULL,

  RECORD_SEQ_NBR         NUMBER(10)             NOT NULL,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center