Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | TABLESPACE_QUOTA |
| Short Name | TSQ |
| View Name | CI_TABLESPACE_QUOTAS |
| Description | Permission to use a tablespace, and the amount of space allocated for |
| that use given to a specific database user | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: NON_ORACLE_DATABASE versionable object ORACLE_DATABASE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
TABLESPACE_REFERENCE DATABASE_USER_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_TSQ |
| Changes: | Summary of changes to TABLESPACE_QUOTA in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| DATABASE_USER_REFERENCE | N |
Prompt: Database User
Transferable only if null |
Must be given to one and only one DATABASE_USER | |
| TABLESPACE_REFERENCE | N |
Prompt: Tablespace
Transferable only if null |
Must be for one and only one TABLESPACE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| QUOTA | NUMBER(38, 0) | Y | Amount of space allocated in the tablespace to the user or the role
Prompt: Quota Range: 0 to 99999999999999999999999999999999999999 | ||
| REMARK | VARCHAR2(240) | Y | A comment or description on the granting of privileges.
Prompt: Comment | ||
| UNITS_OF_QUOTA | VARCHAR2(1) | Y | Units in which quota is expressed
Prompt: Quota Units Uppercase | OGO_UNITS_OF_QUOTA | |
| 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 |
| Other Properties |
|---|
| TABLESPACE_QUOTA 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 TABLESPACE_QUOTA:
Note: