Re: Is there an sql command that I could run on a users schema to generate the sql code for the creation of those objects?

To the best of my knowledge there is no way to do that, I have always used tools like ExpEditor or T.O.A.D. to do that. The draw back is I normally have to do it one object at a time. Don't know if this helps at all, maybe someone knows a better tool than those.

JB

Scott Kerr wrote:

> Hi,
> Is there an sql command that I could run on a users schema to generate the
> sql code for the creation of those objects? I have the DESC command, but
> that only lists fields and properties. The TEXT from USER_OBJECTS dose not
> include TABLES. Is there a way to generate the whole thing? I need to send
> the create script for a development database to a QA database. I could exp
> the database, and they could reinstall it, but I would like to see the SQL
> create code as well.
> Thanks,
> Scott Kerr
Received on Tue Feb 06 2001 - 19:36:16 CET