Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | DATABASE_FILE |
| Short Name | DFI |
| View Name | CI_DATABASE_FILES |
| Description | An operating system file used as a database file. |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Non-instantiable super-type of | DATAFILE |
| LOGFILE | |
| As this is a non-instantiable supertype, follow links (above) to its instantiable subtypes to find versioning information for each subtype, uniqueness criteria, API rules etc | |
| Underlying table: | SDD_DFI |
| Changes: | Summary of changes to DATABASE_FILE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| DATABASE_FILE_TYPE | VARCHAR2(3) | N | Sub-type discriminator. Internal property indicating whether the DATABASE_FILE is a DATAFILE (DAF) or a LOGFILE (LOF)
Not displayed Uppercase System maintained Not updatable by user | DATABASE_FILE_TYPE | |
| FILE_SIZE | NUMBER(10, 0) | Y | The file size e.g. number of bytes in a file.
Prompt: File Size Range: 0 to 9999999999 | ||
| FILE_SIZE_UNIT | VARCHAR2(1) | Y | The units for the size of the block, cluster or file e.g. byte, kilobyte.
Prompt: File Size Unit Uppercase | OGO_UNITS_OF_QUOTA | |
| FULL_PATHNAME | VARCHAR2(240) | Y | Full pathname of file including extension (and node if appropriate).
Prompt: Full Pathname | ||
| NAME | VARCHAR2(100) | N | The name of this file.
Prompt: Name | ||
| REMARK | VARCHAR2(70) | Y | A brief comment about this file.
Prompt: Comment | ||
| REUSE_FLAG | VARCHAR2(1) | N | Indicates whether or not this file will be reused.
Prompt: Reuse ? Uppercase | YESNO | N |
| 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 |
| DESCRIPTION | CDIDSC | Description |
| NOTES | CDINOT | Notes |
| Other Properties |
|---|
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference DATABASE_FILE:
Note: