Re: Generating SQL from database

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Wed, 22 Dec 1999 10:03:44 GMT
Message-ID: <38609d2a.1332265@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 Wed Dec 22 1999 - 04:03:44 CST