Re: Schema sql scripts

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Tue, 16 Apr 2002 14:56:44 GMT
Message-ID: <3CBC3BA6.C76038EA@exesolutions.com>

You can do this with the Oracle EXP and IMP (export and import) utilities that come with every Oracle installation. Read the instructions on how.

You can also do this with Designer, with third-party tools such as ERwin, etc.

One thing to remember is that the scripts created will point to the tablespaces existing in the database you reverse engineered. If the database where you wish to create the schema has different tablespace names the script will need to be modified.

Daniel Morgan

Yaron Avior wrote:

> Hi all,
> Is there a way I can automatically generate from a schema SQL script
> that running it will create the same schema (not including the data -
> only the schema objects including indexes, foreign keys, sequences
> etc.)?
>
> Thanks,
> Yaron
Received on Tue Apr 16 2002 - 09:56:44 CDT