Database Storage Properties dialog: Properties tab

Use this dialog to view and set database storage properties and the materialized view name (or summary table name in pre-Oracle 8.1.7 databases).

For more information, see:

"Managing summary folders"

"Creating summary folders manually"

The following chart lists the attributes and their default values. All but the last four values are editable. When you select a value, the panel at the bottom of the dialog displays a message relating the purpose of the value and the data type it will accept.

Attribute	Datatype	Default Value*	Range	Create/Edit
Table Owner**	alphanumeric	current user		yes
Table Name	alpha	EUL-generated		yes
Tablespace**	alphanumeric	SYSTEM		yes
Initial Extent**	numeric	10K		yes
Next Extent	numeric	10K	minimum data block	yes
% Increase	numeric	50%	>=0%	yes
Min. Extent**	numeric	1	1-Maximum Extent	yes
Max. Extent	numeric	121	> Minimum Extent	yes
% Free	numeric/static	10%	0-100%	yes
% Used	numeric/static	40%	0-99%	yes
Status	alpha/static			read only
# Rows	numeric/static			read only
Error	alpha/static			read only
Last Refreshed				read only
* Default values were obtained from the Oracle SQL Reference Manual. ** Non-dynamic properties; If you change non-dynamic storage properties that affect the placement of existing summary data the summary table completely rebuilds, so these operations can take some time.

The properties, Status, # Rows, and Error, are available only for existing summary folders; that is, a summary folder that has been completed and named. If you are in the Summary Wizard: dialog for internal combinations, these fields are dimmed. If you are in the Edit Summary Combinations dialog, these fields are active.

Notes

This feature does not apply to summary folders based on external summary tables.