Re: Can you DESCRIBE or print a schema?

In article <39013046_at_f573.n115.z1.fidonet.org>

           Michael.Stowe_at_f573.n115.z1.fidonet.org "Michael Stowe" writes:

>*** Quoting Patel_at_Purccvm.Bitnet to All dated 04-21-94 ***
>> Is there a way to get the create table, create index, .. statements
>> from my database?
>
>The export utility can create an export file containing SQL statements
>necessary to create everything in the database, including or excluding data.
>The resultant file can only be used by the import utility, but it is fast and
>requires almost no effort, aside from obtaining the proper username/password.
>
>If you need the statements in ASCII, you can get everything you need from the
>data dictionary, but you'll have to write it yourself in SQL, or locate a tool
>that is capable of this, such as Oracle CASE, which can read the data
>dictionary and generate DDL statements.

It is not at all difficult to process an EXPort with `cat -v`, `sed` & `awk` to generate the SQL to recreate tablespaces, tables, indexes and views. It helps if you don't export the data (or export the data into a different file.)

-- 
Paul Beardsell                          SAM Business Systems Ltd
~~~~~~~~~~~~~~                          21 Finn House, Bevenden St, HOXTON,
pbeardsell_at_cix.compulink.co.uk          Hackney, London, N1-6BN, UK.
paul_at_hoxton.demon.co.uk                 (+44 or 0)71 608-2391