Home -> Usenet -> comp.databases.oracle -> Is there an sql command that I could run on a users schema to generate the sql code for the creation of those objects?

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

From: Scott Kerr <scott.alba_at_verizon.net>
Date: Tue, 06 Feb 2001 18:25:18 GMT
Message-ID: <ikXf6.7911$Nx3.2103148_at_typhoon2.ba-dsg.net> 






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:25:18 CET












Original text of this message