Skip to content

OracleDatabaseInstanceDatabase

Information about Oracle database instance databases.

erDiagram
    Machine ||--o{ OracleDatabaseInstanceDatabase : "MachineID"
    OracleDatabaseInstance ||--o{ OracleDatabaseInstanceDatabase : "OracleDatabaseInstanceID"
    OracleDatabaseInstanceDatabase ||--o{ OracleDatabaseInstanceDatabase : "ContainerOracleDatabaseInstanceDatabaseID"

Fields

Field Type Description
ConId numeric Oracle Database Container ID
ContainerOracleDatabaseInstanceDatabaseID numeric Internal ID that references the OracleDatabaseInstanceDatabase entity (Foreign Key)
Created datetime Date/Time when the record was created in the OctoSAM database
DatabaseType string Type of the Oracle database
DbId numeric Database ID
ExtraData string Additional data related to the Oracle database instance database in JSON format
ID numeric Internal ID for the OracleDatabaseInstanceDatabase entity (Primary Key)
IsConsolidated boolean Indicates if the database is consolidated
MachineID numeric Internal ID that references the Machine entity (Foreign Key)
Name string Name of the Oracle database instance database
OracleDatabaseInstanceID numeric Internal ID that references the OracleDatabaseInstance entity (Foreign Key)
Res1 string Reserved for future use
Res2 string Reserved for future use

References

Column Name Referenced Table Description
ContainerOracleDatabaseInstanceDatabaseID OracleDatabaseInstanceDatabase Information about Oracle database instance databases
MachineID Machine Basic machine information. A machine is a physical or virtual device that can be scanned by OctoSAM Inventory. A machine can also be a mobile device such as a phone or tablet.
OracleDatabaseInstanceID OracleDatabaseInstance Information about Oracle database instances

Referenced by

Table Column Name Description
OracleDatabaseInstanceDatabase ContainerOracleDatabaseInstanceDatabaseID Information about Oracle database instance databases