Database Reference
In-Depth Information
Renaming Tablespaces
Renaming a tablespace can be achieved using the following SQL
statement. Remember that you cannot rename a SYSTEM or
SYSAUX tablespace.
ALTER TABLESPACE hr_01 RENAME TO hr_02;
Bigfile Tablespace (BFT) and Smallfile Tablespace (SFT)
This is a special tablespace introduced in Oracle 10g having only
one data file. You cannot have more than one data file in bigfile
tablespace. This feature is first time introduced in Oracle 10g.
The size of the data file can be as big as 2^32 (4GB) blocks. The
maximum size of the data file can be calculated as
Maximum data file size = (DB_BLOCK_SIZE) * maximum number of blocks
If you have set the DB_BLOCK_SIZE of a database to 8K then
the maximum size of data file will be 32T.
CREATE BIGFILE TABLESPACE hr_01 DATAFILE
'/disk1/oradata/test/payroll_data01.dbf' SIZE 2T
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
Or simply,
CREATE BIGFILE TABLESPACE hr_01 DATAFILE
'/disk1/oradata/test/payroll_data01.dbf' SIZE 1T;
The SIZE represents the data file size and can be specified in
terms of kilobytes (K), megabytes (M), gigabytes (G), or
terabytes (T). Bigfile tablespaces requires extent management as
local with automatic segment-space management (both items are
set by default). An Oracle database can have both BFT and SFT.
SYSTEM and SYSAUX tablespaces are always created as SFT.
Search WWH ::
Custom Search