oracle拆分分区语法详解大全_Oracle 拆分分区（自动）

[php]

/*临时转换表*/

create table SPLIT_TABLE

(

table_name VARCHAR2(30),

partition_name VARCHAR2(30),

high_value CLOB,

tablespace_name VARCHAR2(30),

p_date DATE

)；

/*生成的sql*/

create table SPLIT_TABLE_RSLT

(

table_name VARCHAR2(30),

partition_name VARCHAR2(30),

split_sql VARCHAR2(3000),

insert_date DATE,

app_date DATE,

id NUMBER

)

/*序列，保证sql执行顺序*/

— Create sequence

create sequence SEQ_SPLIT_TABLE_RSLT

minvalue 1

maxvalue 999999999999999999999999999

start with 61

increment by 1

cache 20;

/* 生成分区sql */

CREATE OR REPLACE PROCEDURE SPLIT_TABLE_SQL(V_TABLE_NAME IN VARCHAR2,

V_END_DATE IN VARCHAR2) AUTHID CURRENT_USER AS

N_MONTHS NUMBER;

V_SQL VARCHAR2(300);