|
|
|
Dovetail SchemaEditor allows administrators to specify where particular tables and indexes get physically stored. On Oracle, a physical location is a tablespace, while on Microsoft SQL Server it is a filegroup.
These storage location parameters only apply when creating new tables and indexes. Setting a storage location for an existing table or index has no effect.
The storage location must already exist. Dovetail SchemaEditor will NOT create tablespaces or filegroups.
Example:
<storageLocations defaultLocation="USERS">
<storageLocation location="X_CUSTOM_NAME">
<table name="x_custom_table" />
<index tableName="x_custom_table" name="x_custom_index" />
</storageLocation>
</storageLocations>
See Also |
Next |