% sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Mon Nov 25 10:22:25 2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> CONNECT / AS SYSDBA
Connected.
SQL> CREATE TABLESPACE HT_NC
2 DATAFILE '/data/ora001/oradata/ncedc/HT_NC_PD01.dbf' SIZE 32M
3 AUTOEXTEND ON NEXT 1M MAXSIZE 512M
4 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
5 SEGMENT SPACE MANAGEMENT AUTO
6 BLOCKSIZE 8K;
Tablespace created.
SQL> CREATE TABLESPACE IR_NC
2 DATAFILE '/data/ora001/oradata/ncedc/IR_NC_PD01.dbf' SIZE 32M
3 AUTOEXTEND ON NEXT 1M MAXSIZE 512M
4 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
5 SEGMENT SPACE MANAGEMENT AUTO
6 BLOCKSIZE 8K;
Tablespace created.
SQL> QUIT
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
% sqlplus ncedcdba/****@ncedc
SQL*Plus: Release 9.2.0.1.0 - Production on Mon Nov 25 10:35:49 2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> ALTER TABLE Station ADD PARTITION HT_NC VALUES ('NC') TABLESPACE HT_NC;
Table altered.
SQL> ALTER TABLE Station_Sensor ADD PARTITION HT_NC VALUES ('NC') TABLESPACE HT_NC;
Table altered.
SQL> ALTER TABLE Station_Sensor_Component ADD PARTITION HT_NC VALUES ('NC') TABLESPACE HT_NC;
Table altered.
SQL> ALTER TABLE Station_Filamp ADD PARTITION HT_NC VALUES ('NC') TABLESPACE HT_NC;
Table altered.
SQL> ALTER TABLE Station_Filamp_PChannel ADD PARTITION HT_NC VALUES ('NC') TABLESPACE HT_NC;
Table altered.
SQL> ALTER TABLE Station_Digitizer ADD PARTITION HT_NC VALUES ('NC') TABLESPACE HT_NC;
Table altered.
SQL> ALTER TABLE Station_Digitizer_PChannel ADD PARTITION HT_NC VALUES ('NC') TABLESPACE HT_NC;
Table altered.
SQL> ALTER TABLE Station_Datalogger ADD PARTITION HT_NC VALUES ('NC') TABLESPACE HT_NC;
Table altered.
SQL> ALTER TABLE Station_Datalogger_PChannel ADD PARTITION HT_NC VALUES ('NC') TABLESPACE HT_NC;
Table altered.
SQL> ALTER TABLE Station_Datalogger_LChannel ADD PARTITION HT_NC VALUES ('NC') TABLESPACE HT_NC;
Table altered.
SQL> ALTER TABLE Station_Data ADD PARTITION IR_NC VALUES ('NC') TABLESPACE IR_NC;
Table altered.
SQL> ALTER TABLE Station_Comment ADD PARTITION IR_NC VALUES ('NC') TABLESPACE IR_NC;
Table altered.
SQL> ALTER TABLE Channel_Data ADD PARTITION IR_NC VALUES ('NC') TABLESPACE IR_NC;
Table altered.
SQL> ALTER TABLE Channel_Comment ADD PARTITION IR_NC VALUES ('NC') TABLESPACE IR_NC;
Table altered.
SQL> ALTER TABLE Polynomial ADD PARTITION IR_NC VALUES ('NC') TABLESPACE IR_NC;
Table altered.
SQL> ALTER TABLE Coefficients ADD PARTITION IR_NC VALUES ('NC') TABLESPACE IR_NC;
Table altered.
SQL> ALTER TABLE Decimation ADD PARTITION IR_NC VALUES ('NC') TABLESPACE IR_NC;
Table altered.
SQL> ALTER TABLE Poles_Zeros ADD PARTITION IR_NC VALUES ('NC') TABLESPACE IR_NC;
Table altered.
SQL> ALTER TABLE Sensitivity ADD PARTITION IR_NC VALUES ('NC') TABLESPACE IR_NC;
Table altered.
SQL> ALTER TABLE Simple_Response ADD PARTITION IR_NC VALUES ('NC') TABLESPACE IR_NC;
Table altered.
SQL> QUIT
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
%
Add a new entry with SQL*Plus to the following tables:
WaveServerDefault on DCUCB (Event waveforms).
WaveRoots on DCUCB, PUBLICDB, DCMP2 & TESTUCB (Continuous waveforms).
MaxWaveLength on DCUCB, PUBLICDB, DCMP2 & TESTUCB (Event & Continuous waveforms).
Modify the Makefile to create a Populate_WF_NET application (Continuous waveforms).
Create tablespaces and add to the yearly waveform partitions a sub-partition for the new network.
% sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Oct 31 12:56:12 2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> CONNECT / AS SYSDBA
Connected.
SQL> CREATE TABLESPACE WF_NC_2002
2 DATAFILE '/data/ora001/oradata/ncedc/WF_NC_2002_PD01.dbf' SIZE 16M
3 AUTOEXTEND ON NEXT 1M MAXSIZE 512M
4 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
5 SEGMENT SPACE MANAGEMENT AUTO
6 BLOCKSIZE 8K;
Tablespace created.
SQL> CONNECT ncedcdba
Enter password:
Connected.
SQL> ALTER TABLE waveform
2 MODIFY PARTITION WF_2002
3 ADD SUBPARTITION WF_NC_2002 VALUES ('NC') TABLESPACE WF_NC_2002;
Table altered.
SQL> QUIT
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
%