Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | DATAFILE |
| Short Name | DAF |
| View Name | CI_DATAFILES |
| Description | The definition of the physical file that contains the data of a |
| specific database or tablespace | |
| Sub-type of | DATABASE_FILE |
| Versioning: | Belongs to: NON_ORACLE_DATABASE versionable object ORACLE_DATABASE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
ORACLE_DATABASE_REFERENCE TABLESPACE_REFERENCE NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_DFI |
| Changes: | Summary of changes to DATAFILE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| ORACLE_DATABASE_REFERENCE | N |
Prompt: Oracle Database
Transferable only if null |
Must be for one and only one ORACLE_DATABASE | 49 |
| TABLESPACE_REFERENCE | N |
Prompt: Tablespace
Transferable only if null |
Must be for one and only one TABLESPACE | 49 |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| AUTOEXTEND_FLAG | VARCHAR2(1) | N | Support for autoextend feature of 7.3, indicating whether datafile can be autoextended
Prompt: Autoextend ? Uppercase | YESNO | N |
| 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 Defined on DFI supertype | DATABASE_FILE_TYPE | |
| DATAFILE_FOR | VARCHAR2(3) | N | Arc 49 discriminator. Indicates whether datafile is for a tablespace or a database
Not displayed Uppercase System maintained Not updatable by user | DATAFILE_FOR | |
| FILE_SIZE | NUMBER(10, 0) | Y | The file size e.g. number of bytes in a file.
Prompt: File Size Range: 0 to 9999999999 Defined on DFI supertype | ||
| 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 Defined on DFI supertype | OGO_UNITS_OF_QUOTA | |
| FULL_PATHNAME | VARCHAR2(240) | Y | Full pathname of file including extension (and node if appropriate).
Prompt: Full Pathname Defined on DFI supertype | ||
| MAXIMUM_SIZE | NUMBER(10, 0) | Y | Support for autoextend feature of 7.3, indicating the maximum size of the datafile. Null meaning unlimited
Prompt: Maximum Size Range: 0 to 9999999999 | ||
| MAXIMUM_SIZE_UNITS | VARCHAR2(1) | Y | Support for autoextend feature of 7.3, indicating the units in which the maximum size of the datafile is expressed
Prompt: Maximum Size Unit Uppercase | OGO_UNITS_OF_QUOTA | |
| NAME | VARCHAR2(100) | N | The name of this file.
Prompt: Name Defined on DFI supertype | ||
| NEXT_AUTOEXTEND_AMOUNT | NUMBER(10, 0) | Y | Support for autoextend feature of 7.3, indicating the amount by which to extend the datafile
Prompt: Next Autoextend Amount Range: 0 to 9999999999 | ||
| NEXT_AUTOEXTEND_UNITS | VARCHAR2(1) | Y | Support for autoextend feature of 7.3, indicating the units in which NEXT_AUTOEXTEND_AMOUNT is expressed
Prompt: Next Autoextend Units Uppercase | OGO_UNITS_OF_QUOTA | |
| REMARK | VARCHAR2(70) | Y | A brief comment about this file.
Prompt: Comment Defined on DFI supertype | ||
| REUSE_FLAG | VARCHAR2(1) | N | Indicates whether or not this file will be reused.
Prompt: Reuse ? Uppercase Defined on DFI supertype | 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 Defined on DFI supertype |
Description |
| NOTES | CDINOT Defined on DFI supertype |
Notes |
| Other Properties |
|---|
| DATAFILE 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 DATAFILE:
Note: