DBA Data[Home] [Help] [Dependency Information]

TABLE: CZ.CZ_DB_SETTINGS

Object Details
Object Name: CZ_DB_SETTINGS
Object Type: TABLE
Owner: CZ
FND Design Data: TableCZ.CZ_DB_SETTINGS
Subobject Name:
Status: VALID


CZ_DB_SETTINGS contains information about Oracle Configurator system settings. System settings are organized by section names and identified using setting names. An example of a system setting is "OracleSequenceIncr" in section "SCHEMA". It indicates the increment used in Configurator sequence objects.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Primary Key: CZ_DB_SETTINGS_PK
  1. ColumnSECTION_NAME
  2. ColumnSETTING_ID
Indexes
Index Type Uniqueness Tablespace Column
CZ_DB_SETTINGS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnSECTION_NAME
ColumnSETTING_ID
Columns
Name Datatype Length Mandatory Comments
SETTING_ID VARCHAR2 (40) Yes Data base setting identifier
SECTION_NAME VARCHAR2 (30) Yes Data base setting name
DATA_TYPE NUMBER (8)
Data type of this DB setting 1-integer;2-decimal;3-boolean;4-text -- cf CZ_PROPERTIES
VALUE VARCHAR2 (255)
The active value for this database settings
DESC_TEXT VARCHAR2 (255)
Data base setting description
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SETTING_ID
,      SECTION_NAME
,      DATA_TYPE
,      VALUE
,      DESC_TEXT
FROM CZ.CZ_DB_SETTINGS;

Dependencies

[top of page]

CZ.CZ_DB_SETTINGS does not reference any database object

CZ.CZ_DB_SETTINGS is referenced by following:

SchemaAPPS
SynonymCZ_DB_SETTINGS