Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

Set Oracle Database Table Properties

To set additional Oracle Database Table properties, you use the Table's Tagged Values.

Set Properties

Step

Action

See also

1

Add one or more Tagged Values to the Table, using the names provided in the Property/Tag column of the Properties Table (below).

 

Assign a Tagged Value to an Item

2

Specify the appropriate value for each tag.

Examples are provided in the Value column of this Properties Table.

 

Property/Tag

Value

BUFFER_POOL

DEFAULT

 

CACHE

NOCACHE

 

DBVERSION

9.0.111

 

FREELISTS

1

 

GRANT OWNER1

SELECT

 

GRANT OWNER2

DELETE, INSERT, SELECT, UPDATE

 

INITIAL

65536

 

INITRANS

1

 

LOGGING

LOGGING

 

MAXEXTENTS

2147483645

 

MAXTRANS

255

 

MINEXTENTS

1

 

MONITORING

MONITORING

 

OWNER

OWNER1

 

PARALLEL

NOPARALLEL

 

PCTFREE

10

 

PCTINCREASE

0

 

PCTUSED

0

 

SYNONYMS

PUBLIC:TABLE_PUB;OWNER2:TABLE_OWNER2

 

TABLESPACE

MY_TABLESPACE

 

TEMPORARY

YES

 

 

 

The same properties can be added to indexes and constraints, by highlighting the index or constraint Operation and adding the appropriate Tagged Values.