Re: schema creation

From: James Lorenzen <james_lorenzen_at_allianzlife.com>
Date: Fri, 05 Nov 1999 21:05:51 GMT
Message-ID: <7vvgrc$91a$1@nnrp1.deja.com>

You could use export / import to build the script. 1. Use export to export the schema with no data (rows=n) 2. Use import to "show=y" the ddl for the schema.

The output needs to be formatted, but it is there.

IE
exp name/password full=n rows=n owner=schema_name ... imp name/password show=y full=y file=xxxnamexx.dmp > textfile #reformat with awk (on UNIX)

An awk reformat job is at http://www.tc.umn.edu/~hause011/.

HTH
James

In article <7vjsri$qin$1_at_nnrp1.deja.com>, npomfret2_at_my-deja.com wrote:
> Is there an Oracle tool which produces creation scripts for an already
> existing schema? I've tried Schema Builder but the show SQL option
> just gives me an empty grey text area.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 05 1999 - 15:05:51 CST