Re: Generating SQL from database

From: Donald King <don_at_lagarde.com>
Date: Thu, 23 Dec 1999 18:53:53 -0600
Message-ID: <bBz84.85$PZ3.5442@tw12.nn.bcandid.com>

Will this generate an SQL script that I can send to another user via eMail to run on their end? You will have to forgive me as I am not very familiar with Oracle. I have worked in the past with MS SQL Server and it has a utility for just generating an entire SQL script from a database.

Don

Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam> wrote in message news:38609d2a.1332265_at_news-server...
> On Tue, 21 Dec 1999 10:13:18 -0600, "Donald King" <don_at_lagarde.com>
> wrote:
>
> >I am running Oracle 8.0.4 server. Is there a utility in the Enterprise
> >manager or elsewhere that I can use to generate the SQL from an existing
> >schema that is needed to reproduce the same schema and its tables on
another
> >server? Any help is appreciated. Thanks.
> >
>
> Easy. Export with
> rows=n,indexes=y,constrints=y,grants=y,owner=<schemaname>. Then import
> into the other database. Instant schema clone. Been possible since
> V5, BTW.
>
>
> Cheers
> Nuno Souto
> nsouto_at_nsw.bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
Received on Thu Dec 23 1999 - 18:53:53 CST