Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Schema sql scripts
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
![]() |
![]() |