operations:db_ncedc:new_year_example
CREATE TABLESPACE WF_BK_2020
DATAFILE '/db/ora001/dcucb/WF_BK_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_BP_2020
DATAFILE '/db/ora001/dcucb/WF_BP_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_NC_2020
DATAFILE '/db/ora001/dcucb/WF_NC_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_NN_2020
DATAFILE '/db/ora001/dcucb/WF_NN_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_NP_2020
DATAFILE '/db/ora001/dcucb/WF_NP_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_CI_2020
DATAFILE '/db/ora001/dcucb/WF_CI_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_WR_2020
DATAFILE '/db/ora001/dcucb/WF_WR_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_US_2020
DATAFILE '/db/ora001/dcucb/WF_US_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_PB_2020
DATAFILE '/db/ora001/dcucb/WF_PB_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_LB_2020
DATAFILE '/db/ora001/dcucb/WF_LB_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_SF_2020
DATAFILE '/db/ora001/dcucb/WF_SF_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_AZ_2020
DATAFILE '/db/ora001/dcucb/WF_AZ_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_PG_2020
DATAFILE '/db/ora001/dcucb/WF_PG_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_CE_2020
DATAFILE '/db/ora001/dcucb/WF_CE_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_BG_2020
DATAFILE '/db/ora001/dcucb/WF_BG_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_UW_2020
DATAFILE '/db/ora001/dcucb/WF_UW_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 512M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_UO_2020
DATAFILE '/db/ora001/dcucb/WF_UO_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 512M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_TA_2020
DATAFILE '/db/ora001/dcucb/WF_TA_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 512M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_3B_2020
DATAFILE '/db/ora001/dcucb/WF_3B_2020_PD01.dbf' SIZE 2M
AUTOEXTEND ON NEXT 1M MAXSIZE 512M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_4B_2020
DATAFILE '/db/ora001/dcucb/WF_4B_2020_PD01.dbf' SIZE 2M
AUTOEXTEND ON NEXT 1M MAXSIZE 512M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_5B_2020
DATAFILE '/db/ora001/dcucb/WF_5B_2020_PD01.dbf' SIZE 2M
AUTOEXTEND ON NEXT 1M MAXSIZE 512M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_8B_2020
DATAFILE '/db/ora001/dcucb/WF_8B_2020_PD01.dbf' SIZE 2M
AUTOEXTEND ON NEXT 1M MAXSIZE 512M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_GS_2020
DATAFILE '/db/ora001/dcucb/WF_GS_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 512M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_GM_2020
DATAFILE '/db/ora001/dcucb/WF_GM_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 512M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
CREATE TABLESPACE WF_SB_2020
DATAFILE '/db/ora001/dcucb/WF_SB_2020_PD01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M MAXSIZE 512M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
BLOCKSIZE 8K;
sqlplus repadmin/****@dcucb
EXEC DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY ('master_wf_repg');
EXEC DBMS_REPCAT.ALTER_MASTER_REPOBJECT('ncedcdba','Waveform','TABLE', ddl_text=> 'ALTER TABLE ncedcdba.waveform ADD PARTITION WF_2020 VALUES LESS THAN (1609459227) (SUBPARTITION WF_BK_2020 VALUES (''BK'') TABLESPACE WF_BK_2020, SUBPARTITION WF_NN_2020 VALUES (''NN'') TABLESPACE WF_NN_2020, SUBPARTITION WF_BP_2020 VALUES (''BP'') TABLESPACE WF_BP_2020, SUBPARTITION WF_NP_2020 VALUES (''NP'') TABLESPACE WF_NP_2020, SUBPARTITION WF_CI_2020 VALUES (''CI'') TABLESPACE WF_CI_2020, SUBPARTITION WF_WR_2020 VALUES (''WR'') TABLESPACE WF_WR_2020, SUBPARTITION WF_NC_2020 VALUES (''NC'') TABLESPACE WF_NC_2020, SUBPARTITION WF_US_2020 VALUES (''US'') TABLESPACE WF_US_2020, SUBPARTITION WF_PB_2020 VALUES (''PB'') TABLESPACE WF_PB_2020, SUBPARTITION WF_LB_2020 VALUES (''LB'') TABLESPACE WF_LB_2020, SUBPARTITION WF_SF_2020 VALUES (''SF'') TABLESPACE WF_SF_2020, SUBPARTITION WF_AZ_2020 VALUES (''AZ'') TABLESPACE WF_AZ_2020, SUBPARTITION WF_PG_2020 VALUES (''PG'') TABLESPACE WF_PG_2020, SUBPARTITION WF_CE_2020 VALUES (''CE'') TABLESPACE WF_CE_2020, SUBPARTITION WF_BG_2020 VALUES (''BG'') TABLESPACE WF_BG_2020, SUBPARTITION WF_3B_2020 VALUES (''3B'') TABLESPACE WF_3B_2020, SUBPARTITION WF_4B_2020 VALUES (''4B'') TABLESPACE WF_4B_2020, SUBPARTITION WF_5B_2020 VALUES (''5B'') TABLESPACE WF_5B_2020, SUBPARTITION WF_8B_2020 VALUES (''8B'') TABLESPACE WF_8B_2020, SUBPARTITION WF_UW_2020 VALUES (''UW'') TABLESPACE WF_UW_2020, SUBPARTITION WF_UO_2020 VALUES (''UO'') TABLESPACE WF_UO_2020, SUBPARTITION WF_TA_2020 VALUES (''TA'') TABLESPACE WF_TA_2020, SUBPARTITION WF_GS_2020 VALUES (''GS'') TABLESPACE WF_GS_2020, SUBPARTITION WF_GM_2020 VALUES (''GM'') TABLESPACE WF_GM_2020, SUBPARTITION WF_SB_2020 VALUES (''SB'') TABLESPACE WF_SB_2020)');
BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (
sname => 'ncedcdba',
oname => 'Waveform',
type => 'TABLE',
min_communication => TRUE);
END;
/
EXEC DBMS_REPCAT.RESUME_MASTER_ACTIVITY ('master_wf_repg');
QUIT
operations/db_ncedc/new_year_example.txt · Last modified: 2020/05/27 15:34 by stephane