Element Type Definition: TABLESPACE

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	TABLESPACE
Short Name	OTB
View Name	CI_TABLESPACES
Description	ORACLE tablespace definitions.

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:	DATABASE_REFERENCE NAME
Used by:	Oracle Designer
Underlying table:	SDD_OTB
Changes:	Summary of changes to TABLESPACE in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
DATABASE_REFERENCE	N	Prompt: Database Transferable only if null	Must be part of one and only one DATABASE
STORAGE_DEFINITION_REFERENCE	Y	Prompt: Storage Definition	May be defined for one and only one STORAGE_DEFINITION

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
COMPLETE_FLAG	VARCHAR2(1)	N	Indicates whether the definition of the tablespace is complete and ready to be used by the generators Prompt: Complete ? Uppercase	YESNO	Y
NAME	VARCHAR2(30)	N	The name of the ORACLE tablespace. Prompt: Name Uppercase
ONLINE_FLAG	VARCHAR2(1)	N	Indicates whether or not this tablespace is made available immediately after it has been created on the database. Prompt: Online ? Uppercase	YESNO	Y
READ_ONLY	VARCHAR2(1)	N	Indicates if the TABLESPACE is read-only Prompt: Read Only ? Uppercase	YESNO	N
REMARK	VARCHAR2(240)	Y	A comment as to why this tablespace is required. Prompt: Comment
TEMPORARY_FLAG	VARCHAR2(1)	N	Indicates whether the tablespace is a temporary tablespace (ie can not contain definitions of database objects). A temporary tablespace can only hold temporary objects, or example segments used by implicit sorts to handle ORDER BY clauses Prompt: Temporary Tablespace ? 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
DESRIPTION	CDIDSC	Description
NOTES	CDINOT	Notes

Other Properties
TABLESPACE 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: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference TABLESPACE:

Each CLUSTER_IMPLEMENTATION may be created in one and only one TABLESPACE
Each DATAFILE must be for one and only one TABLESPACE (in arc)
Each DATABASE_USER may be assigned a default tablespace of one and only one TABLESPACE
Each DATABASE_USER may be assigned a temporary tablespace of one and only one TABLESPACE
Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each INDEX_PARTITION may be located in one and only one TABLESPACE
Each INDEX_STORAGE may be for index created in one and only one TABLESPACE
Each LOB_STORAGE may be created in one and only one TABLESPACE
Each LOB_STORAGE may be with LOB index created in one and only one TABLESPACE
Each NESTED_TABLE_STORAGE may be created in one and only one TABLESPACE
Each ROLLBACK_SEGMENT may be created in one and only one TABLESPACE
Each QUEUE_TABLE_IMPLEMENTATION may be created in one and only one TABLESPACE
Each SNAPSHOT_IMPLEMENTATION may be created in one and only one TABLESPACE
Each SERVER_OBJECT_USAGE must be for generation of one and only one CIELEMENT (in arc)
Each TABLE_IMPLEMENTATION may be created in one and only one TABLESPACE
Each TABLE_IMPLEMENTATION may be index only with overflow in one and only one TABLESPACE
Each TABLE_IMPLEMENTATION may be subject of snapshot log created in one and only one TABLESPACE
Each TABLE_PARTITION may be located in one and only one TABLESPACE
Each TABLESPACE_QUOTA must be for one and only one TABLESPACE
Each EXTENDED_STRUCTURE_ELEMENT must be part of one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be use of one and only one ACCESS_CONTROLLED_ELEMENT

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype