Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | TABLE_IMPLEMENTATION |
| Short Name | TBI |
| View Name | CI_TABLE_IMPLEMENTATIONS |
| Description | The implementation of a table in a specific schema. |
| Sub-type of | DB_OBJECT_IMPLEMENTATION |
| Versioning: | Belongs to: NON_ORACLE_DATABASE versionable object ORACLE_DATABASE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
DATABASE_USER_REFERENCE TABLE_DEFINITION_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_DOI |
| Changes: | Summary of changes to TABLE_IMPLEMENTATION in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| DATABASE_USER_REFERENCE | N |
Prompt: Database User
Transferable only if null Defined on DOI supertype |
Must be in schema of one and only one DATABASE_USER | |
| TABLE_DEFINITION_REFERENCE | N |
Prompt: Table
Transferable only if null |
Must be an implementation of one and only one TABLE_DEFINITION | |
| OVERFLOW_TABLESPACE_REFERENCE | Y | Prompt: Overflow Tablespace | May be index only with overflow in one and only one TABLESPACE | |
| REPLICATION_GROUP_REFERENCE | Y | Prompt: Replication Group | May be in one and only one REPLICATION_GROUP | |
| SNAP_LOG_STORAGE_REFERENCE | Y | Prompt: Storage Definition (Log) | May be subject of snapshot log limited by one and only one STORAGE_DEFINITION | |
| SNAP_LOG_TABLESPACE_REFERENCE | Y | Prompt: Tablespace (Log) | May be subject of snapshot log created in one and only one TABLESPACE | |
| STORAGE_DEFINITION_REFERENCE | Y | Prompt: Storage Definition | May be limited by one and only one STORAGE_DEFINITION | |
| TABLESPACE_REFERENCE | Y | Prompt: Tablespace | May be created in one and only one TABLESPACE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| CACHED | VARCHAR2(1) | Y | Indicates if the TABLE is cached
Prompt: Cached Uppercase | CACHED | |
| COMPLETE_FLAG | VARCHAR2(1) | N | Indicates whether the definition of the database object is complete and ready to be used by the generators
Prompt: Complete ? Uppercase Defined on DOI supertype | YESNO | Y |
| DEGREE | NUMBER(6, 0) | Y | Specifies or controls the degree of parallelism. (Property called MAX_SCANS prior to release 2.0)
Prompt: Degree Range: 0 to 999999 | ||
| GLOBAL_SYNONYM_NAME | VARCHAR2(30) | Y | Name to be used by Server Generator when creating synonyms for this object
Prompt: Global Synonym Name Uppercase | ||
| INITIAL_TRANSACTION | NUMBER(3, 0) | Y | The initial number of transaction entries that are allocated.
Prompt: Init Trans Range: 1 to 255 | ||
| INSTANCES | NUMBER(6, 0) | Y | Number of parallel server instances used in parallel operation. (Property was called MIN_PARTITIONS prior to release 2)
Prompt: Instances Range: 0 to 999999 | ||
| LOCKING_SEQUENCE | NUMBER(6, 0) | Y | A number specifying the sequence in which this table is to be locked.
Prompt: Locking Sequence | ||
| MAXIMUM_TRANSACTION | NUMBER(3, 0) | Y | Maximum number of transactions that may update a block concurrently.
Prompt: Max Trans Range: 1 to 255 | ||
| OBJECT_IMPLEMENTATION_TYPE | VARCHAR2(3) | N | Sub-type discriminator. Internal property indicating whether the DB_OBJECT_IMPLEMENTATION is a TABLE_IMPLEMENTATION (TBI), VIEW_IMPLEMENTATION (VWI), SNAPSHOT_IMPLEMENTATION (SNI), SEQUENCE_IMPLEMENTATION (SQI) etc
Not displayed Uppercase System maintained Not updatable by user Defined on DOI supertype | OBJECT_IMPLEMENTATION_TYPE | |
| PARALLEL | VARCHAR2(1) | N | Indicates if parallel querying is to be used
Prompt: Parallel ? Uppercase | YESNO | N |
| PCTTHRESHOLD | NUMBER(3, 0) | Y | Used in the case of an index only table to specify a percentage of the block size beyond which rowdata will be considered overflow
Prompt: Pct Threshold | ||
| PERCENT_FREE | NUMBER(3, 0) | Y | Amount of free space (as a percentage) in a block that is allocated to the table.
Prompt: Percent Free Range: 0 to 99 | ||
| PERCENT_USED | NUMBER(3, 0) | Y | Minimum level of space (as a percentage) in a block that ORACLE maintains for each block.
Prompt: Percent Used Range: 1 to 99 | ||
| SCOPE | VARCHAR2(8) | N | Scope of visibility of the database object, used by the Server generator to determine when database links and synonyms need to be created
Prompt: Scope Uppercase | DB_OBJECT_SCOPE | DATABASE |
| SNAPSHOT_LOG_FLAG | VARCHAR2(1) | N | Indicates whether a materialized view log is to be created for this implementation of the table
Prompt: Materialized View Log ? Uppercase | YESNO | N |
| SNAPSHOT_LOG_INIT_TRANS | NUMBER(3, 0) | Y | The INIT TRANS parameter for the materialized view log of this implementation of the table
Prompt: Init Trans (Log) Range: 1 to 255 | ||
| SNAPSHOT_LOG_MAX_TRANS | NUMBER(3, 0) | Y | The MAX TRANS parameter for the materialized view log of this implemenattion of the table
Prompt: Max Trans (Log) Range: 1 to 255 | ||
| SNAPSHOT_LOG_PERCENT_FREE | NUMBER(3, 0) | Y | The PERCENT FREE parameter for the materialized view log of this implementation of the table
Prompt: Percent Free (Log) Range: 0 to 99 | ||
| SNAPSHOT_LOG_PERCENT_USED | NUMBER(3, 0) | Y | The PERCENT USED parameter for the materialized view log of this implementation of the table
Prompt: Percent Used (Log) Range: 1 to 99 | ||
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs
Not displayed System maintained Updatable only if null Defined on SAC supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs
Not displayed System maintained Not updatable by user Defined on SAC supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| IMPLEMENTATION_DESCRIPTION | IMPDSC Defined on DOI supertype |
Implementation Description |
| IMPLEMENTATION_NOTES | IMPNOT Defined on DOI supertype |
Implementation Notes |
| NON_ORACLE_DATABASE_STORAGE | STODSC | Non-Oracle Storage |
| Other Properties |
|---|
| TABLE_IMPLEMENTATION has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility |
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference TABLE_IMPLEMENTATION:
Note: