Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Schema sql scripts

Re: Schema sql scripts

From: Yaron Avior <yavior_at_mercury.co.il>
Date: 18 Apr 2002 02:13:23 -0700
Message-ID: <1b00d968.0204180113.21090bee@posting.google.com>


Galen Boyer <galendboyer_at_yahoo.com> wrote in message news:<uhemazw8k.fsf_at_rcn.com>...
> On 15 Apr 2002, yavior_at_mercury.co.il wrote:
>
> > 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.)?
>
> exp rows=N
>
> imp ...
>
> The tablespaces may trip you up.

Is it possible to have DDL text files as output, and not binary files (the result of EXP)? Received on Thu Apr 18 2002 - 04:13:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US