Oracle表动态分区 [英] Oracle table dynamic partition
本文介绍了Oracle表动态分区的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在研究Java代码,以根据INSERT_DATETIME字段(时间戳)每15分钟从oracle表中上传数据.我需要根据15分钟的间隔对表进行分区.有没有办法动态地做到这一点(分区).我在oracle SQL开发人员中使用oracle11g.
I'm working on a java code to upload data from oracle tables every 15mins based from the INSERT_DATETIME field (timestamp). I need to partition the tables based on 15minute intervals. is there a way to do it dynamically (partitioning). I'm using oracle11g in oracle SQL developer.
我创建的一个表的一个示例,我想添加一个分区:
A sample of one of the tables I created and I want to add a partition:
CREATE TABLE "PV_TNPM"."TEJAS_CARD_REPORT"
( "INSERT_DATETIME" TIMESTAMP (6) NOT NULL ENABLE,
"NAME" VARCHAR2(100 BYTE),
"IPADDRESS" VARCHAR2(100 BYTE),
"PRODUCTCODE" VARCHAR2(100 BYTE),
"LCTNAME" VARCHAR2(100 BYTE),
"CARDTYPELABEL" VARCHAR2(100 BYTE),
"SOFTWAREVERSION" VARCHAR2(100 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 32768 NEXT 1523712 MINEXTENTS 1 MAXEXTENTS 1017
PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
我对SQL不熟悉,因为上面的代码只是从我创建的表中生成的.任何帮助表示赞赏.谢谢
I'm not familiar with SQL as the above code is just generated from the table I created. Any help is appreciated. thank you
推荐答案
查看全文