Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | BASE_RELATION_LOCATION |
| Short Name | BRL |
| View Name | CI_BASE_RELATION_LOCATIONS |
| Description | For a specific implementation of a view or a snapshot, the |
| corresponding "base relation locations" identify the schemas in | |
| which the underlying objects (ie tables, views or snapshots) are | |
| located. | |
| Base relation locations are not required to be set up, for the | |
| purposes of generating DDL, if the view/snapshot and its underlying | |
| objects are all in the same schema. They are only required if the | |
| underlying objects are in a different schema (or schemas) to the | |
| view/snapshot. | |
| Sub-type of | INTERSECTION |
| Versioning: | Belongs to: NON_ORACLE_DATABASE versionable object ORACLE_DATABASE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
VIEW_IMPLEMENTATION_REFERENCE SNAPSHOT_REFERENCE RELATION_SELECTION_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_BRL |
| Changes: | Summary of changes to BASE_RELATION_LOCATION in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| SNAPSHOT_REFERENCE | N |
Prompt: Materialized View Implement'n
Transferable only if null |
Must be for one and only one SNAPSHOT_IMPLEMENTATION | 54 |
| VIEW_IMPLEMENTATION_REFERENCE | N |
Prompt: View Implementation
Transferable only if null |
Must be for one and only one VIEW_IMPLEMENTATION | 54 |
| DATABASE_USER_REFERENCE | N | Prompt: Database User | Must be implemented from the schema of one and only one DATABASE_USER | |
| RELATION_SELECTION_REFERENCE | N |
Prompt: Relation View Usage
Transferable only if null |
Must be the implementation of one and only one RELATION_SELECTION | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| BASE_RELATION_LOCATION_FOR | VARCHAR2(3) | N | Arc 54 discriminator. Indicates whether the BASE_RELATION_LOCATION relates to a VIEW_IMPLEMENTATION or a SNAPSHOT_IMPLEMENTATION
Not displayed Uppercase System maintained Not updatable by user | BASE_RELATION_LOCATION_FOR | |
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Common repository version identifier of owning PAC
Not displayed System maintained Updatable only if null Defined on SE supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Contains the IRID of the PAC for the "versionable object" to which this element belongs
Not displayed System maintained Not updatable by user Defined on SE supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| Other Properties |
|---|
| BASE_RELATION_LOCATION 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 BASE_RELATION_LOCATION:
Note: