 |
|
Oracle Tips by Burleson |
Setting Up for Use of
Outlines
If you install using the DBCA (Database
Creation Assistant) or through a manula script and run the
catproc.sql script, then the OUTLINE option (in ENTEPRISE edition)
is automatically installed.
The OUTLN schema is created automatically
during installation of Oracle8i and Oracle9i. This schema is granted
connect, resource, and execute any procedure privileges. The OUTLN
schema acts as a place to centrally manage metadata associated with
stored outlines.
Installing OUTLN Schema “After the Fact”
It is possible to install the OUTLN schema
after the databse has been created. As was said above, this is not
usually suggested. Make sure that the OUTLN schema has been dropped
using the cascade option before running this script. You may want to
review the C0800050.sql script for your release in case there have
been updates since the script below was generated. This process
should work for RDBMS release 8.1.5 or greater.
This is an excerpt by
Mike Ault’s e-book:
Using Oracle SQL Stored Outlines & Optimizer Plan Stability
ISBN:
0-9740716-8-4
http://www.rampant-books.com/ebook_plan_stability.htm
|
