Oracle DBMSNCDB Demos

Oracle DBMSNCDB Version 11.2.0.3

General Information

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.

AUTHID

CURRENT_USER

Dependencies

Only STANDARD

First Available

2002

Security Model

Owned by SYS with no privileges granted

Source

{ORACLE_HOME}/rdbms/admin/dbmsncdb.sql

Subprograms

SETUP_FOR_INTERPRETED_COMPILE