CREATE TABLESPACE PART_BASE_DATA DATAFILE
'/data/szxonline/datafile/part_base_data01.dbf' SIZE 4096M AUTOEXTEND OFF,
'/data/szxonline/datafile/part_base_data02.dbf' SIZE 4096M AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM. SIZE 50M
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
'/data/szxonline/datafile/part_base_data01.dbf' SIZE 4096M AUTOEXTEND OFF,
'/data/szxonline/datafile/part_base_data02.dbf' SIZE 4096M AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM. SIZE 50M
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
CREATE TABLESPACE PART_base_INDX DATAFILE
'/data/szxonline/datafile/part_base_indx01.dbf' SIZE 4096M AUTOEXTEND OFF,
'/data/szxonline/datafile/part_base_indx02.dbf' SIZE 4096M AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM. SIZE 50M
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
CREATE TABLE TOPUP.TAB_BASE_OPERATIONLOG_BAK
(
ID NUMBER(19) NOT NULL,
CREATEDATE TIMESTAMP(6) NOT NULL,
DESCRIPTION VARCHAR2(200 CHAR),
LASTDATE TIMESTAMP(6),
OPERATIONCLASS VARCHAR2(100 CHAR),
PK NUMBER(19),
SESSIONID VARCHAR2(100 CHAR),
ACCOUNT_ID NUMBER(19),
OPERATION_ID NUMBER(19)
)
TABLESPACE PART_BASE_DATA
PCTUSED 0
PCTFREE 20
INITRANS 1
MAXTRANS 255
PARTITION BY RANGE (CREATEDATE)
(
PARTITION P201204 VALUES LESS THAN (TIMESTAMP' 2012-04-01 00:00:00')
LOGGING
NOCOMPRESS
TABLESPACE PART_BASE_DATA
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 100M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201207 VALUES LESS THAN (TIMESTAMP' 2012-07-01 00:00:00')
LOGGING
NOCOMPRESS
TABLESPACE PART_BASE_DATA
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 100M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201210 VALUES LESS THAN (TIMESTAMP' 2012-10-01 00:00:00')
LOGGING
NOCOMPRESS
TABLESPACE PART_BASE_DATA
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 100M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201301 VALUES LESS THAN (TIMESTAMP' 2013-01-01 00:00:00')
LOGGING
NOCOMPRESS
TABLESPACE PART_BASE_DATA
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 100M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201304 VALUES LESS THAN (TIMESTAMP' 2013-04-01 00:00:00')
LOGGING
NOCOMPRESS
TABLESPACE PART_BASE_DATA
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 100M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
)
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
(
ID NUMBER(19) NOT NULL,
CREATEDATE TIMESTAMP(6) NOT NULL,
DESCRIPTION VARCHAR2(200 CHAR),
LASTDATE TIMESTAMP(6),
OPERATIONCLASS VARCHAR2(100 CHAR),
PK NUMBER(19),
SESSIONID VARCHAR2(100 CHAR),
ACCOUNT_ID NUMBER(19),
OPERATION_ID NUMBER(19)
)
TABLESPACE PART_BASE_DATA
PCTUSED 0
PCTFREE 20
INITRANS 1
MAXTRANS 255
PARTITION BY RANGE (CREATEDATE)
(
PARTITION P201204 VALUES LESS THAN (TIMESTAMP' 2012-04-01 00:00:00')
LOGGING
NOCOMPRESS
TABLESPACE PART_BASE_DATA
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 100M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201207 VALUES LESS THAN (TIMESTAMP' 2012-07-01 00:00:00')
LOGGING
NOCOMPRESS
TABLESPACE PART_BASE_DATA
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 100M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201210 VALUES LESS THAN (TIMESTAMP' 2012-10-01 00:00:00')
LOGGING
NOCOMPRESS
TABLESPACE PART_BASE_DATA
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 100M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201301 VALUES LESS THAN (TIMESTAMP' 2013-01-01 00:00:00')
LOGGING
NOCOMPRESS
TABLESPACE PART_BASE_DATA
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 100M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201304 VALUES LESS THAN (TIMESTAMP' 2013-04-01 00:00:00')
LOGGING
NOCOMPRESS
TABLESPACE PART_BASE_DATA
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 100M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
)
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
CREATE INDEX TOPUP.IDX_OPERATIONLOGBAK_CREATEDATE ON TOPUP.TAB_BASE_OPERATIONLOG_BAK
(CREATEDATE)
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
LOCAL (
PARTITION P201204
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201207
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201210
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201301
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201304
NOLOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
)
NOPARALLEL;
NOPARALLEL;
CREATE INDEX TOPUP.IDX_OPERATIONLOGBAK_CLASS ON TOPUP.TAB_BASE_OPERATIONLOG_BAK
(OPERATIONCLASS)
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
LOCAL (
PARTITION P201204
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201207
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201210
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201301
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201304
NOLOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
(OPERATIONCLASS)
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
LOCAL (
PARTITION P201204
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201207
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201210
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201301
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201304
NOLOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
)
NOPARALLEL;
NOPARALLEL;
CREATE INDEX TOPUP.IDX_OPERATIONLOGBAK_OPERATID ON TOPUP.TAB_BASE_OPERATIONLOG_BAK
(OPERATION_ID)
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
LOCAL (
PARTITION P201204
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201207
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201210
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201301
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201304
NOLOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
(OPERATION_ID)
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
LOCAL (
PARTITION P201204
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201207
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201210
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201301
LOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P201304
NOLOGGING
NOCOMPRESS
TABLESPACE PART_base_INDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
)
NOPARALLEL;
NOPARALLEL;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25198367/viewspace-734344/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25198367/viewspace-734344/