CREATE TABLE T_BI_CurrentAccountDetailed
(
OrderDate DATE,
BranchFlag varchar2(3),
SortId varchar2(11),
OrderNo varchar2(15),
CustomerId varchar2(11),
AmtOfDebitSide NUMBER(14,2) DEFAULT 0,
AmtOfCreditSide NUMBER(14,2) DEFAULT 0,
Balance NUMBER(14,2) DEFAULT 0,
GrossProfit NUMBER(14,2) DEFAULT 0,
RepayWay varchar2(20),
Remarks varchar2(100),
PRIMARY KEY(OrderDate,BranchFlag,SortId,OrderNo)
)PARTITION BY RANGE(OrderDate)
(PARTITION CAD2008_01 VALUES LESS THAN (TO_DATE('2008-01-01','YYYY-MM-DD')) ,
PARTITION CAD2008_02 VALUES LESS THAN (TO_DATE('2008-02-01','YYYY-MM-DD')) ,
PARTITION CAD2008_03 VALUES LESS THAN (TO_DATE('2008-03-01','YYYY-MM-DD')) ,
PARTITION CAD2008_04 VALUES LESS THAN (TO_DATE('2008-04-01','YYYY-MM-DD')) ,
PARTITION CAD2008_05 VALUES LESS THAN (TO_DATE('2008-05-01','YYYY-MM-DD')) ,
PARTITION CAD2008_06 VALUES LESS THAN (TO_DATE('2008-06-01','YYYY-MM-DD')) ,
PARTITION CAD2008_07 VALUES LESS THAN (TO_DATE('2008-07-01','YYYY-MM-DD')) ,
PARTITION CAD2008_08 VALUES LESS THAN (TO_DATE('2008-08-01','YYYY-MM-DD')) ,
PARTITION CAD2008_09 VALUES LESS THAN (TO_DATE('2008-09-01','YYYY-MM-DD')) ,
PARTITION CAD2008_10 VALUES LESS THAN (TO_DATE('2008-10-01','YYYY-MM-DD')) ,
PARTITION CAD2008_11 VALUES LESS THAN (TO_DATE('2008-11-01','YYYY-MM-DD')) ,
PARTITION CAD2008_12 VALUES LESS THAN (TO_DATE('2008-12-01','YYYY-MM-DD')) ,
PARTITION CAD2009_01 VALUES LESS THAN (TO_DATE('2009-01-01','YYYY-MM-DD')) ,
PARTITION CAD2009_02 VALUES LESS THAN (TO_DATE('2009-02-01','YYYY-MM-DD')) ,
PARTITION CAD2009_03 VALUES LESS THAN (TO_DATE('2009-03-01','YYYY-MM-DD')) ,
PARTITION CAD2009_04 VALUES LESS THAN (TO_DATE('2009-04-01','YYYY-MM-DD')) ,
PARTITION CAD2009_05 VALUES LESS THAN (TO_DATE('2009-05-01','YYYY-MM-DD')) ,
PARTITION CAD2009_06 VALUES LESS THAN (TO_DATE('2009-06-01','YYYY-MM-DD')) ,
PARTITION CAD2009_07 VALUES LESS THAN (TO_DATE('2009-07-01','YYYY-MM-DD')) ,
PARTITION CAD2009_08 VALUES LESS THAN (TO_DATE('2009-08-01','YYYY-MM-DD')) ,
PARTITION CAD2009_09 VALUES LESS THAN (TO_DATE('2009-09-01','YYYY-MM-DD')) ,
PARTITION CAD2009_10 VALUES LESS THAN (TO_DATE('2009-10-01','YYYY-MM-DD')) ,
PARTITION CAD2009_11 VALUES LESS THAN (TO_DATE('2009-11-01','YYYY-MM-DD')) ,
PARTITION CAD2009_12 VALUES LESS THAN (TO_DATE('2009-12-01','YYYY-MM-DD'))
);
-- Add comments to the table
comment on table T_BI_CurrentAccountDetailed
is '往来账明细';
-- Add comments to the columns
comment on column T_BI_CurrentAccountDetailed.ORDERDATE
is '日期';
comment on column T_BI_CurrentAccountDetailed.BRANCHFLAG
is '分公司标识';
comment on column T_BI_CurrentAccountDetailed.sortid
is '流水号';
comment on column T_BI_CurrentAccountDetailed.ORDERNO
is '单据编号';
comment on column T_BI_CurrentAccountDetailed.CUSTOMERID
is '客户内码';
comment on column T_BI_CurrentAccountDetailed.AMTOFDEBITSIDE
is '借方金额';
comment on column T_BI_CurrentAccountDetailed.AMTOFCREDITSIDE
is '贷方金额';
comment on column T_BI_CurrentAccountDetailed.BALANCE
is '余额';
comment on column T_BI_CurrentAccountDetailed.GROSSPROFIT
is '毛利';
comment on column T_BI_CurrentAccountDetailed.REPAYWAY
is '还款方式';
comment on column T_BI_CurrentAccountDetailed.REMARKS
is '备注';
增(追)加分区:
alter table T_BI_SUMOFCUSSALES add PARTITION SOCS2010_01
VALUES LESS THAN (TO_DATE('2010-01-01','YYYY-MM-DD'))
tablespace RPTFACT2010
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 10M
minextents 1
maxextents unlimited
);
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/pkushinhwa/archive/2009/12/21/5047214.aspx
分享到:
相关推荐
oracle表空间创建
步骤简单易学,适合自学ORACLE表空间的同学
创建表空间,创建用户分配权限,设置表空间自增长,修改大小
oracle创建一个表空间创建临时表空间创建用户表空间资源的权限
Oracle创建表空间、创建用户并指定表空间、给用户授予权限
Oracle 表空间建立方法
oracle 创建用户及表空间,及用户权限分配
/*第1步:创建临时表空间 */ create temporary tablespace user_temp tempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local; ...
Oracle创建表空间.创建用户.创建表
数据库备份恢复时,获取oracle表空间脚本,创建用户等
oracle数据库导入、导出数据、创建表空间、创建用户、用户授权等操作
Oracle创建临时表空间、表空间的创建代码
oracle数据库用户、表空间创建语句
linux系统下创建oracle表空间和用户权限查询,安装Oracle系统时可以用到。
oracle 创建表空间脚本 create tablespace
oracle 11G创建表空间、用户、密码、索引、分配权限、删除表空间、数据泵导入、导出
oracle创建表空间、创建用户、并为用户分配相关权限的语句。
创建表空间参数详解,创建表空间参数详解,创建表空间参数详解
linux下创建oracle用户表空间的方法
oracle 创建表空间 导入导出 详细阐述 oracle创建用户,表空间 及导入导出数据的个人经验。