Purpose
Use the CREATE TABLESPACE SET statement to create a tablespace set. A tablespace set can be used in a sharded database as a logical storage unit for one or more sharded tables and indexes.
A tablespace set consists of multiple tablespaces distributed across shards in a shardspace. The database automatically creates the tablespaces in a tablespace set. The number of tablespaces is determined automatically and is equal to the number of chunks in the corresponding shardspace.
All tablespaces in a tablespace set are permanent bigfile tablespaces; a tablespace set does not contain SYSTEM, undo, or temporary tablespaces. The database automatically creates one data file for each tablespace. All tablespaces in a tablespace set share the same attributes. You can modify attributes for all tablespaces in a tablespace set with the ALTER TABLESPACE SET statement.
Prerequisites
You must be connected to a shard catalog database as an SDB user.
You must have the CREATE TABLESPACE system privilege.
Syntax
Semantics
tablespace_set
Specify the name of the tablespace set to be created. The name must satisfy the requirements listed in Database Object Naming Rules.
IN SHARDSPACE
Specify this clause if you are using composite sharding. For shardspace_name, specify the name of the shardspace in which the tablespace set is to be created.
Omit this clause if you are using system-managed sharding. In this case, the tablespace set is created in the default shardspace for the sharded database.
USING TEMPLATE
The USING TEMPLATE clause allows you to specify attributes for the tablespaces in the tablespace set.
The DATAFILE and permanent_tablespace_attrs clauses have the same semantics here as for the CREATE TABLESPACE statement, with the following exceptions:
For the DATAFILE file_specification clause, you can specify only the SIZE clause and the autoextend_clause.
You cannot specify the MINIMUM EXTENT size_clause.
For the segment_management_clause, you can specify only SEGMENT SPACE MANAGEMENT AUTO. The MANUAL setting is not supported.
Examples
Creating a Tablespace Set: Example
The following statement creates tablespace set ts1:
CREATE TABLESPACE SET ts1
IN SHARDSPACE sgr1
USING TEMPLATE
( DATAFILE SIZE 100m
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
);
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4