Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Schema sql scripts
Not with EXP but you can easily write your own using SQL*Plus and SPOOL.
Daniel Morgan
Yaron Avior wrote:
> 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 - 12:25:46 CDT