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

 

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

Learn More