Logical Structure of the Database
As a DBA, you can create new tablespaces, resize data files associated to the tablespaces, add files to tablespaces, set default segment storage settings, alter default segment storage settings, make tablespaces read-only or read-write, make tablespaces temporary or permanent, and drop tablespaces.
Recall that the database architecture includes both the logical structure (tablespaces, segments, extents, and data blocks) and the physical structure (control files, online redo log files, and data files).
The Oracle Server enables the DBA to maintain fine-grained control of disk space through the use of the logical structures.
The logical structures tablespaces, extents, and segments are the means by which the DBA ... |
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
