Database Reference
In-Depth Information
•
Undo tablespace (prefixed UNDOTBS): For automatic logs due to
data changes (this is particularly useful for data rollbacks and/or
data recoveries after a catastrophe).
•
Users tablespace (prefixed USER): For storing user created tables.
A full discussion of Oracle tablespaces is beyond the scope of this course. However,
in the interest of a credible introduction, Figure
11-6
provides the syntax of the
Create-
Tablespace
statement, along with an example.
Figure 11-6.
Syntax for Create-Tablespace Statement