Database Reference
In-Depth Information
There are two kinds of tablespaces based on the storage
management. One is called “Locally Managed” tablespace and
the other one is “Dictionary Managed” tablespace. In all pre-
Oracle9i systems, there was only one tablespace type i.e.
Dictionary Managed and you had to take care of segments and
extents within the tablespace.
In Oracle10g all sorts of management of segments and extents
are done by Oracle all you have to add is “EXTENT
MANGEMENT LOCAL”. If you want a locally managed
tablespace to have the segment's free space managed by Oracle,
you must include the clause, SEGMENT SPACE
MANAGEMENT AUTO. Once done then you don't even have
to worry about PCTUSED and FREELISTS used in pre-Oracle9i
releases.
Manual Database Design: Step 8
Run Scripts to Build Data Dictionary Views
Run the necessary scripts required to build data dictionary view.
They
are
located
under
the
directory
ORACLE_HOME/rdbms/admin.
Remember SYS is the owner of all the data dictionary view so
you have to connect to Oracle Instance as SYS as shown below.
CONNECT SYS/password AS SYSDBA
The scripts you need to run are CATALOG.sql and
CATPROC.sql. Once done all the data dictionary view will be
created for you.
Manual Database Design: Step 9
Run Scripts to Install Additional Options (Optional)
This is optional step. If you need to install any of the optional
products like InterMedia or Spatial, you can run the scripts to
Search WWH ::
Custom Search