Re: How do I script object creation?

Weasel wrote:
> Hello all,
>
> I have a frustrating problem: how do I replicate the effects of
> SQLserver's "Generate SQL script" function in Oracle?
>
> For those unfamiliar with the functionality, you can designate any
> objects, across any schema, and SQLserver will automatically generate
> all DDL for creating the object (in the case of tables and indexes,
> they will be created as empty objects).

A demo of the DBMS_METADATA package can be found in Morgan's Library at www.psoug.org.

You coulld also do it with Streams and various other techniques depending on your Oracle version (not named) and edition (not named).

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)