Re: Duplicating Oracle DB w/o Schema or Scripts

In <33E1FB9E.94C_at_uk.sun.com> John Rudman <john.rudman_at_uk.sun.com> writes:
>> 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 once had a PERL filter that understood the output of a full export file format such that you basically extracted the DDL of every object in the export.

I think you could probably take the output of the .dmp file without exporting data from the database and run a very rudimentary combiner type program across it to find a good first approximation.

-- 
Kids say it best:        Andrew Finkenstadt (http://www.supernet.net/~kahuna/)

Dear GOD, I didn't think orange went with purple until I saw 
the sunset you made on Tuesday.  That was cool!  -- Eugene