• Create tablespaces and update the HT & IR partitions with the new network.

% 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
%