Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Set Oracle Table Properties
To set additional Oracle table properties, you use the table's Tagged Values
How to
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 reference table below.
|
|
2 |
Specify the appropriate value for each tag. Examples are provided in the Value column of the reference table below.
|
|
The same properties can be added to indexes and constraints, by highlighting the index or constraint Operation and adding the appropriate Tagged Values.
Reference
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
|
