Re: batch generating of DDL for a set of tables

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 21 Aug 2001 05:44:39 -0700
Message-ID: <9ltl3n01t4o@drn.newsguy.com>

In article <c18ea449.0108210353.7a66fb89_at_posting.google.com>, crsoza_at_hotmail.com says...
>

>
>I am interested in finding the source for dbms_metadata. I have 9i
>RDBMS on linux but this package doesn't seem to exist in
>$ORACLE_HOME/rdbms/admin area. Can someone post or forward me the
>source for these package (crsoza_at_hotmail.com)?. can someone also
>confirm whether or not this package will work under 8i ?.
>
>Cheers, Chris

It should be installed by default, there is a catmeta and a dbmsmeta.sql in $OH/rdbms/admin and a prvtmeta.plb.

If it is not there, its a "bug".

You can not take packages from one release and use in another (so no, you cannot put it in an 8i instance)

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Tue Aug 21 2001 - 07:44:39 CDT