Xref: alice comp.databases.oracle.server:78849
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!gw12.nn.bcandid.com!gate.bCandid.com!hub12.nn.bcandid.com!tw12.nn.bcandid.com.POSTED!not-for-mail
From: "Donald King" <don@lagarde.com>
Newsgroups: comp.databases.oracle.server
References: <83o8b0$6gu$1@grendel.sunflower.com> <38609d2a.1332265@news-server>
Subject: Re: Generating SQL from database
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Message-ID: <bBz84.85$PZ3.5442@tw12.nn.bcandid.com>
X-Trace: tw12.nn.bcandid.com 945997255 204.233.56.1 (Thu, 23 Dec 1999 18:00:55 MST)
NNTP-Posting-Date: Thu, 23 Dec 1999 18:00:55 MST
Organization: bCandid - Powering the world's discussions - http://bCandid.com
Date: Thu, 23 Dec 1999 18:53:53 -0600

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@nsw.bigpond.net.au.nospam> wrote in message
news:38609d2a.1332265@news-server...
> On Tue, 21 Dec 1999 10:13:18 -0600, "Donald King" <don@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@nsw.bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html