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.

 

How to Add a Tagged Value

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