Creating tablespaces

Note: Active Storage Manager expects the TableSpace to follow the IEE Standard TableSpace Naming Conventions. The TableSpace Naming Conventions can be found in the AddReadingPartitions.pls script delivered with the 10.3 Installer. TableSpace names are case insensitive and are always stored as uppercase even if referenced in mixed case. For more information, see Active Storage Manager in the IEE MDM Help.

Use the following procedure to create tablespaces for partitioned and non-partitioned tables:

  1. Verify that you have enough space to support the tablespace sizes. The script runs and creates 12 database files (DBFs).

  2. Edit the script OracleDatabaseFiles/Tablespaces/CreateDeployTablespaces

    1. Replace <ORADIR> with the directory path appropriate to your installation.

    2. Save the script and exit.

  3. Run SQL*Plus, connecting as the DBA user, and execute: SQL>@OracleDatabaseFiles/Tablespaces/CreateDeployTablespaces.pls

  4. Edit the script.

    OracleDatabasefiles/Tablespaces/CreateDeployTablespacesReading.pls.

    1. Consult with the Itron Professional Services delivery team for the earliest year and number of years required for the Reading table.

    2. Replace <ORADIR> with the directory path appropriate to your installation.

    3. Replace <####> with the four-digit year of the earliest year for which reading data will be stored in IEE.

    4. If more than one year will be needed, copy and paste the 12 CREATE TABLESPACE statements and replace the year number with the next consecutive year number.

      Note: Partitions and tablespaces must always be created consecutively with no gaps.

    5. Save the script and exit.

  5. Run SQL*Plus, connecting as the DBA User and execute:

    SQL>@OracleDatabaseFiles/Tablespaces/CreateDeployTablespacesReading.pls

  6. Repeat steps 4 and 5 for each of the following scripts:

    • CreateDeployTablespacesDCL.pls for table DeviceCommLog
    • CreateDeployTablespacesDE.pls for table DeviceEvent
    • CreateDeployTablespacesRGSPC.pls for table ReadingGroupSPC
    • CreateDeployTablespacesVLDH.pls for table ValidationLogDetailHistory
    • CreateDeployTablespacesVLH.pls for table ValidationLogHistory

    • CreateDeployTablespacesAOD.pls for table AgentOutcomeData

    • CreateDeployTablespacesAOE.pls for table AgentOutcomeEvent

    • CreateDeployTablespacesSNH.pls for table SysNotificationHist

    • CreateDeployTablespacesSNHG.pls for table SysNotificationHistGrp