select count(*) from JMS_NEWS t where t.type='0103';
delete from JMS_NEWS t where t.type='0103';
201701011200000000000
201610200053219204579 21位
201610011043246970245
总共:
PR:108082
NEWS:25955
SELECT tablespace_name, segment_name, segment_type, blocks FROM dba_segments
WHERE segment_name = 'MON_PROCESS_RECORD_BACK';
create tablespace ADC_BACK_1 datafile 'D:\OracleBack\ADC_1.dnf' size 100M;
create tablespace ADC_BACK_2 datafile 'D:\OracleBack\ADC_2.dnf' size 100M;
create tablespace ADC_BACK_3 datafile 'D:\OracleBack\ADC_3.dnf' size 100M;
create tablespace ADC_BACK_4 datafile 'D:\OracleBack\ADC_4.dnf' size 100M;
create tablespace ADC_BACK_5 datafile 'D:\OracleBack\ADC_5.dnf' size 100M;
select tablespace_name from dba_tablespaces;
select count(*) from MON_PROCESS_RECORD_BACK
create table MON_PROCESS_RECORD_BACK(
INFOID VARCHAR2(36),
DIC_FLOWTYPE_ID VARCHAR2(36),
START_TIME DATE,
END_TIME DATE,
IS_SUCCESS CHAR(1),
ERROR_CODE VARCHAR2(2000),
DEL_FLAG CHAR(1),
ID VARCHAR2(36) PRIMARY KEY,
DEALWAY CHAR(1),
DETAIL VARCHAR2(4000),
DIC_EB_PLATFORM_ID VARCHAR2(36),
STATE VARCHAR2(100),
INSTRUCTION_ID VARCHAR2(36),
INSTRUCTION_NUM VARCHAR2(4),
EBI_INFO_CODE VARCHAR2(50),
IS_DISPLAY VARCHAR2(1)
)
partition by range(EBI_INFO_CODE)(
partition part_01 values less than('201608100000000000000') tablespace ADC_BACK_1,
partition part_02 values less than('201609100000000000000') tablespace ADC_BACK_2,
partition part_03 values less than('201610100000000000000') tablespace ADC_BACK_3,
partition part_04 values less than('201611100000000000000') tablespace ADC_BACK_4,
partition part_05 values less than('201612300000000000000') tablespace ADC_BACK_5,
partition part_06 values less than(maxvalue) tablespace USERS
);
insert into MON_PROCESS_RECORD_BACK(
INFOID,
DIC_FLOWTYPE_ID,
START_TIME,
END_TIME,
IS_SUCCESS,
ERROR_CODE,
DEL_FLAG,
ID,
DEALWAY,
DETAIL,
DIC_EB_PLATFORM_ID,
STATE,
INSTRUCTION_ID,
INSTRUCTION_NUM,
EBI_INFO_CODE,
IS_DISPLAY
)
select
INFOID,
DIC_FLOWTYPE_ID,
START_TIME,
END_TIME,
IS_SUCCESS,
ERROR_CODE,
DEL_FLAG,
ID,
DEALWAY,
DETAIL,
DIC_EB_PLATFORM_ID,
STATE,
INSTRUCTION_ID,
INSTRUCTION_NUM,
EBI_INFO_CODE,
IS_DISPLAY
from MON_PROCESS_RECORD;
创建多个表空间(表分区)
最新推荐文章于 2024-05-13 21:37:40 发布