Set Oracle Table Properties

For Oracle, you can set table properties using the table's Tagged Values. Follow the steps below:

  1. Select the Tagged Values tab of the table Properties dialog. The Tagged Values tab shows the tags for the table.
  2. Click on the New Tag button NewTagIcon. The Tagged Value dialog displays.
  3. Define the table properties as shown in the examples below:
     
    oracle_tag_tablespace
     
    oracle_tag_storage
     
  4. 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/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 properties defined for a given table are listed on the Tagged Values tab, as illustrated by the following typical Tagged Value list:

oracle_tag_disabled