Duplicating Oracle DB w/o Schema or Scripts

Hi,

[Quoted] Does anyone know of a method to generate a sql script or schema to create the tables, views, etc, of an Oracle/7 database? I am thinking about just massaging query output from the USER_* data dictionary tables using Sql*Plus, perl, and a bunch of elbow grease, but it seems like there should be an easier way (yeah-i know-like maintaining the schema definitions in a script from the beginning).

Any suggestions are appreciated (especially via e-mail since I don't browse here all the time)

-tom
Tom-n-Tracy_at_msn.com Received on Tue Jul 29 1997 - 00:00:00 CEST