| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
This view displays tablespace information from the control file.
| Column | Datatype | Description |
|---|---|---|
TS# |
NUMBER |
Tablespace number |
NAME |
VARCHAR2(30) |
Tablespace name |
INCLUDED_IN_DATABASE_BACKUP |
VARCHAR2(3) |
Indicates whether the tablespace is included in full database backups using the BACKUP DATABASE RMAN command (YES) or not (NO). NO only if the CONFIGURE EXCLUDE RMAN command was used for this tablespace. |
BIGFILE |
VARCHAR2(3) |
Indicates whether the tablespace is a bigfile tablespace (YES) or not (NO) |
FLASHBACK_ON |
VARCHAR2(3) |
Indicates whether the tablespace participates in FLASHBACK DATABASE operations (YES) or not (NO) |
|
 Copyright © 2002, 2003, Oracle Corporation All Rights Reserved. |
|
