- 浏览: 164254 次
- 性别:
- 来自: 南京
文章分类
- 全部博客 (327)
- JAVA (130)
- 工作笔记 (49)
- SQLSERVER (5)
- ORACLE (28)
- nginx (1)
- Unix C (16)
- 系统 (19)
- 网络技术 (17)
- WEB前端 (22)
- Eclipse (2)
- Tomcat (1)
- spring (7)
- MYSQL (12)
- Maven (6)
- JETTY (2)
- 设计 (2)
- 开源项目 (7)
- asterisk (0)
- C++ (2)
- WINDOWS (2)
- SCALA (0)
- 协议 (1)
- Netty (1)
- SHELL (1)
- mybaits (4)
- 并发 (2)
- 架构 (2)
- TCP/IP (8)
- 虚拟化 (3)
- 不要再说java慢 (0)
- mac (2)
- mysql乱码完美解决 (1)
最新评论
-----------------------------------------------------
-- Export file for user SCOTT --
-- Created by Administrator on 2013-5-16, 15:31:31 --
-----------------------------------------------------
--http://wenku.baidu.com/view/6894a5290066f5335a812157.html###
--修改用户密码:
alter user scott identified by 123;
--解锁用户:
alter user scott account unlock;
--scott 赋权限 用sys 账号进入。
--http://www.itpub.net/thread-1748738-1-1.html 增加分区(MaxValue)
--新建文件夹
--E:\LTE_Data
--创建表空间
create tablespace LTE_C datafile 'E:\LTE_Data\ltec.dbf' size 50m AUTOEXTEND ON;
create tablespace LTE_U datafile 'E:\LTE_Data\lteu.dbf' size 50m AUTOEXTEND ON;
--增加表空间文件
--alter tablespace USERS add datafile 'G:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS03.DBF' size 50M AUTOEXTEND ON;
--删除表空间
--drop tablespace LTE_C
-- Create table
create table ASSOCIATIONTABLE
(
imei VARCHAR2(50),
imsi VARCHAR2(50),
enbid VARCHAR2(10),
ci VARCHAR2(10),
ip VARCHAR2(20)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
next 1
minextents 1
maxextents unlimited
);
--spool apptest_create_20130516.log
----prompt
----prompt Creating table APPTYPEINFO
----prompt ==========================
----prompt
create table APPTYPEINFO
(
datetime DATE,
appdllen NUMBER(12),
appdlspeed NUMBER(12,2),
applen NUMBER(12),
appmaxdlspeed NUMBER(12,2),
apptype VARCHAR2(50),
appullen NUMBER(12),
appulspeed NUMBER(12,2),
avgdelay NUMBER(12,2),
avglen NUMBER(12,2),
cellid VARCHAR2(50),
enbid VARCHAR2(50),
enbip VARCHAR2(20),
errorrate NUMBER(12,2),
errpacketnumber NUMBER(12),
imsi VARCHAR2(50),
maxdelay NUMBER(12,2),
mifiip VARCHAR2(50),
mifimac VARCHAR2(50),
packetnumber NUMBER(12),
timelen NUMBER(12),
userdllen NUMBER(12),
userdlspeed NUMBER(12,2),
userid VARCHAR2(200),
userip VARCHAR2(50),
userullen NUMBER(12),
userulspeed NUMBER(12,2),
vlanid VARCHAR2(20)
)
PARTITION BY RANGE(datetime)
(
PARTITION part1 VALUES LESS THAN(TO_DATE('2013-9-30 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part2 VALUES LESS THAN(TO_DATE('2013-10-1 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part3 VALUES LESS THAN(TO_DATE('2013-10-2 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part4 VALUES LESS THAN(TO_DATE('2013-10-3 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part5 VALUES LESS THAN(TO_DATE('2013-10-4 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part6 VALUES LESS THAN(TO_DATE('2013-10-5 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part7 VALUES LESS THAN(TO_DATE('2013-10-6 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part8 VALUES LESS THAN(TO_DATE('2013-10-7 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part9 VALUES LESS THAN(TO_DATE('2013-10-8 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part10 VALUES LESS THAN(TO_DATE('2013-10-9 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part11 VALUES LESS THAN(TO_DATE('2013-10-10 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part12 VALUES LESS THAN(TO_DATE('2013-10-11 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part13 VALUES LESS THAN(TO_DATE('2013-10-12 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part14 VALUES LESS THAN(TO_DATE('2013-10-13 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part15 VALUES LESS THAN(TO_DATE('2013-10-14 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part16 VALUES LESS THAN(TO_DATE('2013-10-15 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part17 VALUES LESS THAN(TO_DATE('2013-10-16 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part18 VALUES LESS THAN(TO_DATE('2013-10-17 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part19 VALUES LESS THAN(TO_DATE('2013-10-18 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part20 VALUES LESS THAN(TO_DATE('2013-10-19 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part21 VALUES LESS THAN(TO_DATE('2013-10-20 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part22 VALUES LESS THAN(TO_DATE('2013-10-21 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part23 VALUES LESS THAN(TO_DATE('2013-10-22 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part24 VALUES LESS THAN(TO_DATE('2013-10-23 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part25 VALUES LESS THAN(TO_DATE('2013-10-24 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part26 VALUES LESS THAN(TO_DATE('2013-10-25 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part27 VALUES LESS THAN(TO_DATE('2013-10-26 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part28 VALUES LESS THAN(TO_DATE('2013-10-27 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part29 VALUES LESS THAN(TO_DATE('2013-10-28 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part30 VALUES LESS THAN(TO_DATE('2013-10-29 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part31 VALUES LESS THAN(TO_DATE('2013-10-30 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part32 VALUES LESS THAN(TO_DATE('2013-10-31 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part33 VALUES LESS THAN(TO_DATE('2013-11-1 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part34 VALUES LESS THAN(TO_DATE('2013-11-2 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part35 VALUES LESS THAN(TO_DATE('2013-11-3 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part36 VALUES LESS THAN(TO_DATE('2013-11-4 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part37 VALUES LESS THAN(TO_DATE('2013-11-5 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part38 VALUES LESS THAN(TO_DATE('2013-11-6 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part39 VALUES LESS THAN(TO_DATE('2013-11-7 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part40 VALUES LESS THAN(TO_DATE('2013-11-8 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part41 VALUES LESS THAN(TO_DATE('2013-11-9 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part42 VALUES LESS THAN(TO_DATE('2013-11-10 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part43 VALUES LESS THAN(TO_DATE('2013-11-11 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part44 VALUES LESS THAN(TO_DATE('2013-11-12 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part45 VALUES LESS THAN(TO_DATE('2013-11-13 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE
汪日平 17:51:21
PARTITION BY RANGE(datetime)
(
PARTITION part1 VALUES LESS THAN(TO_DATE('2013-9-30 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part2 VALUES LESS THAN(TO_DATE('2013-10-1 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part3 VALUES LESS THAN(TO_DATE('2013-10-2 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part4 VALUES LESS THAN(TO_DATE('2013-10-3 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part5 VALUES LESS THAN(TO_DATE('2013-10-4 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part6 VALUES LESS THAN(TO_DATE('2013-10-5 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part7 VALUES LESS THAN(TO_DATE('2013-10-6 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part8 VALUES LESS THAN(TO_DATE('2013-10-7 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part9 VALUES LESS THAN(TO_DATE('2013-10-8 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part10 VALUES LESS THAN(TO_DATE('2013-10-9 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part11 VALUES LESS THAN(TO_DATE('2013-10-10 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part12 VALUES LESS THAN(TO_DATE('2013-10-11 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part13 VALUES LESS THAN(TO_DATE('2013-10-12 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part14 VALUES LESS THAN(TO_DATE('2013-10-13 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part15 VALUES LESS THAN(TO_DATE('2013-10-14 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part16 VALUES LESS THAN(TO_DATE('2013-10-15 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part17 VALUES LESS THAN(TO_DATE('2013-10-16 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part18 VALUES LESS THAN(TO_DATE('2013-10-17 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part19 VALUES LESS THAN(TO_DATE('2013-10-18 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part20 VALUES LESS THAN(TO_DATE('2013-10-19 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part21 VALUES LESS THAN(TO_DATE('2013-10-20 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part22 VALUES LESS THAN(TO_DATE('2013-10-21 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part23 VALUES LESS THAN(TO_DATE('2013-10-22 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part24 VALUES LESS THAN(TO_DATE('2013-10-23 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part25 VALUES LESS THAN(TO_DATE('2013-10-24 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part26 VALUES LESS THAN(TO_DATE('2013-10-25 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part27 VALUES LESS THAN(TO_DATE('2013-10-26 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part28 VALUES LESS THAN(TO_DATE('2013-10-27 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part29 VALUES LESS THAN(TO_DATE('2013-10-28 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part30 VALUES LESS THAN(TO_DATE('2013-10-29 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part31 VALUES LESS THAN(TO_DATE('2013-10-30 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part32 VALUES LESS THAN(TO_DATE('2013-10-31 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part33 VALUES LESS THAN(TO_DATE('2013-11-1 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part34 VALUES LESS THAN(TO_DATE('2013-11-2 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part35 VALUES LESS THAN(TO_DATE('2013-11-3 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part36 VALUES LESS THAN(TO_DATE('2013-11-4 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part37 VALUES LESS THAN(TO_DATE('2013-11-5 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part38 VALUES LESS THAN(TO_DATE('2013-11-6 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part39 VALUES LESS THAN(TO_DATE('2013-11-7 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part40 VALUES LESS THAN(TO_DATE('2013-11-8 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part41 VALUES LESS THAN(TO_DATE('2013-11-9 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part42 VALUES LESS THAN(TO_DATE('2013-11-10 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part43 VALUES LESS THAN(TO_DATE('2013-11-11 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part44 VALUES LESS THAN(TO_DATE('2013-11-12 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part45 VALUES LESS THAN(TO_DATE('2013-11-13 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part46 VALUES LESS THAN(TO_DATE('2013-11-14 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part47 VALUES LESS THAN(TO_DATE('2013-11-15 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part48 VALUES LESS THAN(TO_DATE('2013-11-16 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part49 VALUES LESS THAN(TO_DATE('2013-11-17 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part50 VALUES LESS THAN(TO_DATE('2013-11-18 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part51 VALUES LESS THAN(TO_DATE('2013-11-19 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part52 VALUES LESS THAN(TO_DATE('2013-11-20 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part53 VALUES LESS THAN(TO_DATE('2013-11-21 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part54 VALUES LESS THAN(TO_DATE('2013-11-22 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part55 VALUES LESS THAN(TO_DATE('2013-11-23 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part56 VALUES LESS THAN(TO_DATE('2013-11-24 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part57 VALUES LESS THAN(TO_DATE('2013-11-25 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part58 VALUES LESS THAN(TO_DATE('2013-11-26 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part59 VALUES LESS THAN(TO_DATE('2013-11-27 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part60 VALUES LESS THAN(TO_DATE('2013-11-28 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part61 VALUES LESS THAN(TO_DATE('2013-11-29 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part62 VALUES LESS THAN(TO_DATE('2013-11-30 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part63 VALUES LESS THAN (MAXVALUE)TABLESPACE LTE_C
-- Export file for user SCOTT --
-- Created by Administrator on 2013-5-16, 15:31:31 --
-----------------------------------------------------
--http://wenku.baidu.com/view/6894a5290066f5335a812157.html###
--修改用户密码:
alter user scott identified by 123;
--解锁用户:
alter user scott account unlock;
--scott 赋权限 用sys 账号进入。
--http://www.itpub.net/thread-1748738-1-1.html 增加分区(MaxValue)
--新建文件夹
--E:\LTE_Data
--创建表空间
create tablespace LTE_C datafile 'E:\LTE_Data\ltec.dbf' size 50m AUTOEXTEND ON;
create tablespace LTE_U datafile 'E:\LTE_Data\lteu.dbf' size 50m AUTOEXTEND ON;
--增加表空间文件
--alter tablespace USERS add datafile 'G:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS03.DBF' size 50M AUTOEXTEND ON;
--删除表空间
--drop tablespace LTE_C
-- Create table
create table ASSOCIATIONTABLE
(
imei VARCHAR2(50),
imsi VARCHAR2(50),
enbid VARCHAR2(10),
ci VARCHAR2(10),
ip VARCHAR2(20)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
next 1
minextents 1
maxextents unlimited
);
--spool apptest_create_20130516.log
----prompt
----prompt Creating table APPTYPEINFO
----prompt ==========================
----prompt
create table APPTYPEINFO
(
datetime DATE,
appdllen NUMBER(12),
appdlspeed NUMBER(12,2),
applen NUMBER(12),
appmaxdlspeed NUMBER(12,2),
apptype VARCHAR2(50),
appullen NUMBER(12),
appulspeed NUMBER(12,2),
avgdelay NUMBER(12,2),
avglen NUMBER(12,2),
cellid VARCHAR2(50),
enbid VARCHAR2(50),
enbip VARCHAR2(20),
errorrate NUMBER(12,2),
errpacketnumber NUMBER(12),
imsi VARCHAR2(50),
maxdelay NUMBER(12,2),
mifiip VARCHAR2(50),
mifimac VARCHAR2(50),
packetnumber NUMBER(12),
timelen NUMBER(12),
userdllen NUMBER(12),
userdlspeed NUMBER(12,2),
userid VARCHAR2(200),
userip VARCHAR2(50),
userullen NUMBER(12),
userulspeed NUMBER(12,2),
vlanid VARCHAR2(20)
)
PARTITION BY RANGE(datetime)
(
PARTITION part1 VALUES LESS THAN(TO_DATE('2013-9-30 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part2 VALUES LESS THAN(TO_DATE('2013-10-1 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part3 VALUES LESS THAN(TO_DATE('2013-10-2 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part4 VALUES LESS THAN(TO_DATE('2013-10-3 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part5 VALUES LESS THAN(TO_DATE('2013-10-4 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part6 VALUES LESS THAN(TO_DATE('2013-10-5 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part7 VALUES LESS THAN(TO_DATE('2013-10-6 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part8 VALUES LESS THAN(TO_DATE('2013-10-7 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part9 VALUES LESS THAN(TO_DATE('2013-10-8 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part10 VALUES LESS THAN(TO_DATE('2013-10-9 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part11 VALUES LESS THAN(TO_DATE('2013-10-10 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part12 VALUES LESS THAN(TO_DATE('2013-10-11 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part13 VALUES LESS THAN(TO_DATE('2013-10-12 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part14 VALUES LESS THAN(TO_DATE('2013-10-13 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part15 VALUES LESS THAN(TO_DATE('2013-10-14 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part16 VALUES LESS THAN(TO_DATE('2013-10-15 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part17 VALUES LESS THAN(TO_DATE('2013-10-16 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part18 VALUES LESS THAN(TO_DATE('2013-10-17 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part19 VALUES LESS THAN(TO_DATE('2013-10-18 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part20 VALUES LESS THAN(TO_DATE('2013-10-19 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part21 VALUES LESS THAN(TO_DATE('2013-10-20 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part22 VALUES LESS THAN(TO_DATE('2013-10-21 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part23 VALUES LESS THAN(TO_DATE('2013-10-22 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part24 VALUES LESS THAN(TO_DATE('2013-10-23 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part25 VALUES LESS THAN(TO_DATE('2013-10-24 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part26 VALUES LESS THAN(TO_DATE('2013-10-25 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part27 VALUES LESS THAN(TO_DATE('2013-10-26 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part28 VALUES LESS THAN(TO_DATE('2013-10-27 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part29 VALUES LESS THAN(TO_DATE('2013-10-28 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part30 VALUES LESS THAN(TO_DATE('2013-10-29 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part31 VALUES LESS THAN(TO_DATE('2013-10-30 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part32 VALUES LESS THAN(TO_DATE('2013-10-31 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part33 VALUES LESS THAN(TO_DATE('2013-11-1 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part34 VALUES LESS THAN(TO_DATE('2013-11-2 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part35 VALUES LESS THAN(TO_DATE('2013-11-3 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part36 VALUES LESS THAN(TO_DATE('2013-11-4 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part37 VALUES LESS THAN(TO_DATE('2013-11-5 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part38 VALUES LESS THAN(TO_DATE('2013-11-6 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part39 VALUES LESS THAN(TO_DATE('2013-11-7 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part40 VALUES LESS THAN(TO_DATE('2013-11-8 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part41 VALUES LESS THAN(TO_DATE('2013-11-9 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part42 VALUES LESS THAN(TO_DATE('2013-11-10 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part43 VALUES LESS THAN(TO_DATE('2013-11-11 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part44 VALUES LESS THAN(TO_DATE('2013-11-12 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_U,
PARTITION part45 VALUES LESS THAN(TO_DATE('2013-11-13 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE
汪日平 17:51:21
PARTITION BY RANGE(datetime)
(
PARTITION part1 VALUES LESS THAN(TO_DATE('2013-9-30 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part2 VALUES LESS THAN(TO_DATE('2013-10-1 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part3 VALUES LESS THAN(TO_DATE('2013-10-2 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part4 VALUES LESS THAN(TO_DATE('2013-10-3 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part5 VALUES LESS THAN(TO_DATE('2013-10-4 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part6 VALUES LESS THAN(TO_DATE('2013-10-5 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part7 VALUES LESS THAN(TO_DATE('2013-10-6 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part8 VALUES LESS THAN(TO_DATE('2013-10-7 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part9 VALUES LESS THAN(TO_DATE('2013-10-8 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part10 VALUES LESS THAN(TO_DATE('2013-10-9 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part11 VALUES LESS THAN(TO_DATE('2013-10-10 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part12 VALUES LESS THAN(TO_DATE('2013-10-11 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part13 VALUES LESS THAN(TO_DATE('2013-10-12 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part14 VALUES LESS THAN(TO_DATE('2013-10-13 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part15 VALUES LESS THAN(TO_DATE('2013-10-14 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part16 VALUES LESS THAN(TO_DATE('2013-10-15 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part17 VALUES LESS THAN(TO_DATE('2013-10-16 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part18 VALUES LESS THAN(TO_DATE('2013-10-17 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part19 VALUES LESS THAN(TO_DATE('2013-10-18 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part20 VALUES LESS THAN(TO_DATE('2013-10-19 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part21 VALUES LESS THAN(TO_DATE('2013-10-20 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part22 VALUES LESS THAN(TO_DATE('2013-10-21 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part23 VALUES LESS THAN(TO_DATE('2013-10-22 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part24 VALUES LESS THAN(TO_DATE('2013-10-23 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part25 VALUES LESS THAN(TO_DATE('2013-10-24 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part26 VALUES LESS THAN(TO_DATE('2013-10-25 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part27 VALUES LESS THAN(TO_DATE('2013-10-26 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part28 VALUES LESS THAN(TO_DATE('2013-10-27 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part29 VALUES LESS THAN(TO_DATE('2013-10-28 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part30 VALUES LESS THAN(TO_DATE('2013-10-29 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part31 VALUES LESS THAN(TO_DATE('2013-10-30 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part32 VALUES LESS THAN(TO_DATE('2013-10-31 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part33 VALUES LESS THAN(TO_DATE('2013-11-1 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part34 VALUES LESS THAN(TO_DATE('2013-11-2 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part35 VALUES LESS THAN(TO_DATE('2013-11-3 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part36 VALUES LESS THAN(TO_DATE('2013-11-4 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part37 VALUES LESS THAN(TO_DATE('2013-11-5 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part38 VALUES LESS THAN(TO_DATE('2013-11-6 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part39 VALUES LESS THAN(TO_DATE('2013-11-7 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part40 VALUES LESS THAN(TO_DATE('2013-11-8 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part41 VALUES LESS THAN(TO_DATE('2013-11-9 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part42 VALUES LESS THAN(TO_DATE('2013-11-10 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part43 VALUES LESS THAN(TO_DATE('2013-11-11 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part44 VALUES LESS THAN(TO_DATE('2013-11-12 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part45 VALUES LESS THAN(TO_DATE('2013-11-13 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part46 VALUES LESS THAN(TO_DATE('2013-11-14 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part47 VALUES LESS THAN(TO_DATE('2013-11-15 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part48 VALUES LESS THAN(TO_DATE('2013-11-16 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part49 VALUES LESS THAN(TO_DATE('2013-11-17 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part50 VALUES LESS THAN(TO_DATE('2013-11-18 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part51 VALUES LESS THAN(TO_DATE('2013-11-19 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part52 VALUES LESS THAN(TO_DATE('2013-11-20 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part53 VALUES LESS THAN(TO_DATE('2013-11-21 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part54 VALUES LESS THAN(TO_DATE('2013-11-22 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part55 VALUES LESS THAN(TO_DATE('2013-11-23 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part56 VALUES LESS THAN(TO_DATE('2013-11-24 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part57 VALUES LESS THAN(TO_DATE('2013-11-25 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part58 VALUES LESS THAN(TO_DATE('2013-11-26 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part59 VALUES LESS THAN(TO_DATE('2013-11-27 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part60 VALUES LESS THAN(TO_DATE('2013-11-28 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part61 VALUES LESS THAN(TO_DATE('2013-11-29 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part62 VALUES LESS THAN(TO_DATE('2013-11-30 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE LTE_C,
PARTITION part63 VALUES LESS THAN (MAXVALUE)TABLESPACE LTE_C
发表评论
-
oracle 分页
2015-09-17 20:31 547SELECT * FROM (SELECT A.*, R ... -
Oracle IMPDP如何改变索引表空间
2015-08-11 13:22 894转自 http://blog.sina.com.cn/s/b ... -
批量造数据
2015-08-01 17:19 0CREATE OR REPLACE PROCEDURE ES_ ... -
11g归档
2015-03-23 22:31 403数据库归档 http://blog.sina.com.cn/s ... -
数据库压力测试
2015-03-21 22:04 545http://www.cnblogs.com/rootq/ar ... -
明天试试这个视图
2015-03-19 21:12 365V$SEGMENT_STATISTICS 用法 -
Oracle建立序列
2015-03-16 12:02 554create sequence hibernate_seq ... -
netstat 的使用
2015-03-09 16:48 486netstat -ltpe 查看当前活跃的连接 http:/ ... -
关于位图索引的帖子
2015-03-09 12:33 455http://www.itpub.net/thread-183 ... -
【转】Oracle 使用lock_sga和pre_page_sga参数保证SGA常驻物理内存
2015-03-09 11:33 509http://blog.csdn.net/laoshangxy ... -
视图的用法
2015-02-27 21:30 386关于视图的概念 http://blog.sina.com.cn ... -
oracle调优方法
2015-02-25 11:07 408一上午 10:36:13 这个东西需要看报表是吧? 大 ... -
ORACLE 伪列
2014-08-05 16:20 315多个不同的表要UNION在一起得出结果,为了统一输出结果,要用 ... -
表空间 用户 表
2014-04-24 16:48 3671. 创建一个表空间 create tablespace L ... -
工作中用的两条查询语句,LEFT JOIN多张表的
2013-09-13 16:57 905----4G手机 left join 三张表 select a ... -
Split
2013-07-25 20:59 749CREATE OR REPLACE TYPE type_spl ... -
蒙昭良的博客地址.
2013-06-21 15:01 888http://space.itpub.net/12778571 ... -
Oracle 数据库用户管理
2013-06-21 14:57 401Oracle 数据库用户管理 Oracle 权限设置 一、权限 ... -
ORACLE中的五种约束
2013-06-21 13:48 831CREATE TABLE TABLENAMEEXAMLE( ... -
查看Oracle数据库表空间(转)
2013-06-21 13:25 448/* *时间:2009-04-01 *环境:AIX5.3 ...
相关推荐
Oracle分区技术是一种数据库管理系统(DBMS)特性,用于将大型表和索引分割成更小、更易管理和处理的部分,从而提升查询性能和数据管理效率。这种技术特别适用于数据仓库和决策支持系统(DSS),因为这些系统通常...
根据提供的文件信息,本文将详细解释Oracle分区技术及其在解决UNDOTBS01.DBF文件过大问题中的应用方法,并进一步探讨Oracle分区的不同类型及其应用场景。 ### Oracle 分区概述 Oracle分区是一种将大表或索引分割成...
【Oracle分区表用法】 Oracle分区表是一种高级的数据库管理技术,它将大型表的数据分散存储在不同的物理区域,以提升查询效率和系统的整体性能。本文将详细介绍分区表的概念、作用、优缺点,以及各种类型的分区表...
标签“oracle分区表 自动维护”概括了脚本的核心功能和使用场景,说明脚本主要用于Oracle数据库的分区表自动维护。 从提供的部分内容中,我们可以看到脚本的具体实现细节: 1. 创建基础表`PART_T_MAINTENANCE`,...
Oracle分区表是数据库管理系统Oracle中的一个高级特性,用于将大表分成较小、更易管理的部分,从而提高查询性能,优化存储管理和数据维护。在大型企业级应用中,尤其是在处理大量数据时,分区表是不可或缺的技术手段...
Oracle 分区表及分区索引 Oracle 分区表是指将一个大表分割成多个小表,每个小表称为一个分区,分区表的优点是可以提高查询性能、改善管理型、增强容错性等。 分区表的分类: 1. 范围分区(Range Partitioning) ...
Oracle分区技术是数据库管理系统中用于优化大规模数据存储和查询性能的一种高级特性。它允许将大表和索引分成较小、更易管理和操作的部分,每个部分称为一个分区。分区的主要目标是提高查询性能、简化管理任务并增强...
### Oracle 分区表详解 #### 一、Oracle 分区简介 Oracle 的分区技术是一种用于管理和优化超大型表和索引的有效手段。通过将一个大型的表或者索引分割成多个较小且可管理的部分,分区技术能够显著提升数据库的性能...
Oracle分区表中的Hash分区是一种基于哈希算法的分区策略,适用于处理无法清晰定义分区范围的大型数据表。这种分区方式通过计算分区键的哈希值来决定数据存储在哪个分区,以此达到数据分散和负载均衡的目的。Hash分区...
下面我们将深入探讨Oracle分区表和锁的应用。 一、Oracle分区表 1. **分区概念**:Oracle分区表是将一个大表逻辑上划分为多个较小的部分,每个部分称为一个分区。每个分区都有自己的索引和维护操作,这使得对大...
oracle分区资料· oracle分区资料· oracle分区资料·
### 导入导出Oracle分区表数据 #### 一、概述 在Oracle数据库管理中,对分区表进行数据的导入与导出是一项常见的任务。分区技术可以显著提高大型表的性能,尤其是在处理大规模数据集时。为了有效地管理和迁移这些...
总结来说,Oracle分区表是一种有效管理大规模数据的手段,通过合理分区,可以显著提升查询效率,简化维护工作,并提供更高的数据可用性。然而,使用分区也需要权衡其带来的复杂性和额外的存储需求。正确理解和应用...
### ORACLE 分区表的创建详解 #### 一、概述 在Oracle数据库中,分区是一种高效的数据管理方式,尤其适用于大型表和索引组织表。通过将数据逻辑地分割成多个独立的部分(即分区),可以显著提高查询性能,并简化表...
#### 一、Oracle分区概述 在Oracle数据库中,分区技术是一种非常有效的管理大型表和索引的方法。通过将一个大的表或索引分成多个较小的部分(分区),可以显著提高查询性能,并简化表和索引的管理。 #### 二、何时...
Oracle 分区表全揭秘 ,非常详细,oracle dba可以看看
#### 一、Oracle分区表概述 在Oracle数据库中,分区是一种对大型表进行物理分割的方法,它可以显著提高查询性能并简化数据管理任务。通过将一个大表分成多个较小的部分(即分区),可以更快地执行查询操作,尤其是...
简单讲解了oracle分区技术-大批量数据操作