 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 5 - Oracle Database
Objects
Oracle9i Tablespace Changes
Oracle9i provides the database
administrator with a variety (read that bewildering array) of new
tablespace parameters and block sizes. Administrators are now able
to create Oracle managed tablespaces, user managed tablespaces,
locally managed tablespaces, dictionary managed tablespaces, specify
AUTOALLOCATE, UNIFORM, PERMANENT, UNDO as well as select block sizes
of 2K, 4K, 8K, 16K, or 32K.
The tablespace definition below combines a few
of the aforementioned options:
CREATE TABLESPACE oracle_local_auto DATAFILE
SIZE 5M BLOCKSIZE 2K;
Many of the parameters were not specified
intentionally to highlight some of the default specifications for
Oracle9i tablespaces. Although some of the parameters we will review
were introduced in earlier releases, it is important to discuss them
to obtain a clear understanding of tablespace administration in
Oracle9i. Let’s continue our discussion by taking a closer look at
the tablespace’s definition:
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques
ISBN 0-9744355-3-8
by Christopher T. Foot
http://www.rampant-books.com/book_2003_2_OCP_print.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
