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.