Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
250
Primary key: ONS155XX_FLASH_DEVICE_PK
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-181: ONS155xx_Flash_Device_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
FlashDevDBID
NUMBER(10)
NOT NULL
Unique sequence number generated by
database. This is the link between this
table and other tables that contain
Flash partition information.
database. This is the link between this
table and other tables that contain
Flash partition information.
NEDBAccessID
NUMBER(10)
NOT NULL
Database ID of the NE containing the
Flash device; same as NEDBAccessID in
the NE_Info_Table.
Flash device; same as NEDBAccessID in
the NE_Info_Table.
FlashDevIndex
NUMBER(2)
NOT NULL
Flash device sequence number to index
within the ciscoFlashDeviceTable.
within the ciscoFlashDeviceTable.
FlashDevName
VARCHAR2(16)
NOT NULL
Flash device name that refers to the
device within the NE.
device within the NE.
FlashDevSize
NUMBER(10)
DEFAULT 0
Total size of the Flash device.
FlashDevPartitions
NUMBER(2)
DEFAULT 1
Number of Flash device partitions.
CPUSlotNum
NUMBER(2)
DEFAULT –1
Slot number of the CPU where the
Flash device exists.
Flash device exists.
Status
NUMBER(2)
DEFAULT –1
Status of the Flash bank (active or
inactive).
inactive).
1.1.186
ONS155xx_Flash_Partition_Table
The ONS155xx_Flash_Partition_Table stores all the Flash partitions for each Flash device
for a given ONS 155xx. Only the read/write Flash partitions are considered.
for a given ONS 155xx. Only the read/write Flash partitions are considered.
Primary key: ONS155XX_FLASHPART_PK
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-182: ONS155xx_Flash_Partition_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
FlashPartDBID
NUMBER(10)
NOT NULL
Unique ID generated by database to
identify a row in this table.
identify a row in this table.
FlashDevDBID
NUMBER(10)
NOT NULL
ID of the Flash device.
FlashPartIndex
NUMBER(2)
NOT NULL
Flash partition sequence number to
index within the
ciscoFlashPartitionTable.
index within the
ciscoFlashPartitionTable.