Chapter 14 DBMS-Specific Features
The following extended attributes are defined by default in the Oracle DBMS.
The following extended attributes are available for attributes of abstract data types of type OBJECT or SQLJ_OBJECT on the Oracle tab:
| Name | Internal Code | Description |
|---|---|---|
| Declare REF | RefAttribute | Generates a REF modifier on attribute to declare references, which hold pointers to objects. |
The following extended attributes are available on the Oracle tab:
| Name | Internal Code | Description |
|---|---|---|
| Deferred option of check constraint | ExtColumnDeferOption | Defines the deferred option of a column constraint check. It is used in the definition or create and add items statements. |
| Name of not null constraint | ExtNotNullConstraintName | Defines the name of the not null constraint for a column. |
| Deferred option of not null constraint | ExtNotNullDeferOption | Defines the deferred option of a column not null constraint. It is used in "create" and "add" statement items definition.
An empty value means "Not deferrable". |
The following extended attributes are available on the Oracle tab:
| Name | Internal Code | Description |
|---|---|---|
| Add serially_reusable pragma on package specification | IsSpecPragma | When set to True, defines that the pragma serially_reusable clause must be applied on the database package specification. |
| Add serially_reusable pragma on package body | IsPragma | When set to True, defines that the pragma serially_reusable clause must be applied on the database package body declaration. |
The following extended attributes are available on the Oracle tab:
| Name | Internal Code | Description |
|---|---|---|
| Deferred option of foreign key constraint | ExtReferenceDeferOption | Defines the deferred option of a reference. It is used in the definition of create and add items statements. |
The following extended attributes are available on the Oracle tab:
| Name | Internal Code | Description |
|---|---|---|
| Type | ExtTableType | Defines if the table is of type global temporary or not. |
The following extended attributes are available on the Oracle tab:
| Name | Internal Code | Description |
|---|---|---|
| Size specification | SizeSpecification | Specifies whether the tablespace is a bigfile or smallfile tablespace. This clause overrides any default tablespace type setting for the database. You can choose from the following settings:
|
| Temporary tablespace | Temporary | Use this option to create a locally managed temporary tablespace, which is an allocation of space in the database that can contain transient data that persists only for the duration of a session. This transient data cannot be recovered after process or instance failure. |
| Undo tablespace | Undo | Use this option to create an undo tablespace. When you run the database in automatic undo management mode, Oracle Database manages undo space using the undo tablespace instead of rollback segments. This clause is useful if you are now running in automatic undo management mode but your database was not created in automatic undo management mode. |
The following extended attributes are available on the Oracle tab:
| Name | Internal Code | Description |
|---|---|---|
| Super view object | ExtObjSuperView | Used in the UNDER clause to specify the superview the current object view is based on. |
| Object view key | ExtObjOIDList | Specifies the attributes of the object type that will be used as a key to identify each row in the object view. |
| Object view type | ExtObjViewType | Defines the type of the object view. |
| Force | ExtViewForce | When set to TRUE, allows you to create the view regardless of the existence of the base tables or the owner privileges on these tables. |
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |