|Purpose||This package provides setup routines for compiling a database native and back to interpreted.|
|Note||* This script must be run using SQL*PLUS.
* You must be connected AS SYSDBA to run this script.
* This package is to be used in conjunction with dbmsupgnv.sql and dbmsupgin.sql and not on its own.
If you encounter the exception,. Database is not open for migration, execute "SHUTDOWN", "STARTUP UPGRADE" and re-execute the setup call (setup_for_native_compile or setup_for_interpreted_compile)
By default, bodyOnly set to TRUE) means, only the following kinds of objects will be setup for native compile: PROCEDURE, FUNCTION, TRIGGER, PACKAGE BODY, and TYPE BODY. That is, PACKAGE specifications and TYPE specifications are excluded. If bodyOnly is FALSE then PACKAGE specifications are included in the list of objects setup for native compilation while TYPE specifications continue to be excluded.
There is reason to believe that this may only be safe when run in a 9i environment so do not use this without prior testing on a database you are willing to sacrifice.
If you choose to run this procedure be sure you do so, as indicated, via the scripts $ORACLE_HOME/rdbms/admin/dbmsupgnv.sql or /dbmsupgin.sql.
|Security Model||Owned by SYS with no privileges granted|
|Setup the database for native compilation||dbmsncdb.setup_for_native_compile;|
|Changes the default compile to native||dbmsncdb.setup_for_native_compile(bodyOnly IN BOOLEAN DEFAULT TRUE);|
|This site is maintained by Dan Morgan. Last Updated:||This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2013 Daniel A. Morgan All Rights Reserved|