|Oracle9i Supplied PL/SQL Packages and Types Reference
Release 2 (9.2)
Part Number A96612-01
This package provides various utility subprograms.
DBMS_UTILITY submits a job for each partition. It is the users responsibility to control the number of concurrent jobs by setting the
JOB_QUEUE_PROCESSES correctly.There is minimal error checking for correct syntax. Any error is reported in SNP trace files.
This chapter discusses the following topics:
DBMS_UTILITY runs with the privileges of the calling user for the
ANALYZE_SCHEMA procedures. This is necessary so that the SQL works correctly.
This does not run as
SYS. The privileges are checked using
Lists of "
@LINK should be stored here.
NAME should be stored here.
Lists of database links should be stored here.
The order in which objects should be generated is returned here.
The order in which objects should be generated is returned here for users.
TYPE instance_record IS RECORD ( inst_number NUMBER, inst_name VARCHAR2(60)); TYPE instance_table IS TABLE OF instance_record INDEX BY BINARY_INTEGER;
The list of active instance number and instance name.
The starting index of
instance_table is 1;
instance_table is dense.