Database maintainance utilities(4)

 

The REBIND Utility:

This utility command can be used to recreate a package stored in the database without the need for a bind file. The basic command syntax for REBIND is this:

    REBIND <PACKAGE> [PackageName] <VERSION [VersionID]> <APREUSE [YES | NO]>

    <RESOLVE [ANY | CONSERVATIVE]>

    <REOPT [NONE | ONCE | ALWAYS] >

Consider the following:

 PackageName: Identifies the name to assign to the package to rebind

VersionID: Identifies a specific version of the package to be rebound

If you want to REBIND the package DEMO.PACKAGE to the database, you can use the following command:

REBIND PACKAGE demo.package;

If you create any new indexes in a table that the DEMO.PACKAGE relies on, you should rebind the package to make use of the newly created indexes.