Set Oracle Table Properties |
For Oracle, you can set table properties using the table's Tagged Values. Follow the steps below:
- Select the View | Tagged Values menu option, or press [Ctrl]+[Shift]+[6]. The Tagged Values window displays.
- Click on the table in a diagram or in the Project Browser. The Tagged Values window displays the table name, selected.
- Click on the
(New Tag) button. - Define the table properties as shown in the examples below:
- Click on the OK button to save the Tagged Value.
All available properties for an Oracle table are listed below.
Note: |
The same properties can be added to indexes and constraints. Highlight the index or constraint and add the properties as Tagged Values. |
Property |
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 properties defined for a given table are listed on the Tagged Values window, as illustrated by the following typical Tagged Value list:
