Set Oracle Database Table Properties

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

Set Properties

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

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.

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.

  • 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