Re: is dbms_ddl an Oracle provided PLSQl package?

It's an Oracle-supplied package which
can be created by script:

$ORACLE_HOME/rdbms/admin/dbmsutil.sql

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Stan Brown wrote in message <9u8769$eft$1_at_panix2.panix.com>...


>A few months ago, i set up to routinely run some of the script from the

>O'riely "Oracle Scripts" book.

>

>Now I'm trying to figure out some things that are going on in my new

>instanec, as I bring it u inot production. In reading through the

>aabalyze.sql script I find that other than repirting stastics, the core of

>it is:

>

>/* Analyze each index for this table */

>dbms_ddl.analyze_object('INDEX', lv_owner,

>lv_index_name, 'COMPUTE');

>

>Problem is I'm not certain where the package dbms_ddl gets defined. It does

>not appear to be defined in any of the scripts from this book.

>

>So, is it a standared Oracle supplied PLSQL package?

>

>If so, where can I find some documnetation on it?

>

>

>

>--

>"They that would give up essential liberty for temporary safety deserve

>neither liberty nor safety."

> -- Benjamin Franklin