Alexander,
Running an export with the parameter ROWS=N will give you just the DDL
statements for the database, with no data.
Todd Owers
In article <84v74q$kae$1_at_nnrp1.deja.com>,
Owais Anjum <owais_anjum_at_my-deja.com> wrote:
> In article <84uove$9pq$1_at_nnrp1.deja.com>,
> M. Armaghan Saqib <armaghan_at_yahoo.com> wrote:
> > My freeware tool SQLPlusPlus gives you commands to extract DDL into
a
> > text file.
> >
> > For example to get DDL for all tables in SCOTT, you execute
> >
> > EXEC s.GETTAB('%','SCOTT')
> >
> > in SQL Plus
> >
> > Download it free.
> >
> > regards,
> > M. Armaghan Saqib
> >
>
> > * SQL PlusPlus : Add power to SQL Plus command line
> > * SQL Link for XL : Integrate Oracle with XL
> > * Oracle CBT with sample GL (Triggers and Forms Source Code
included.
> > Download free: http://www.geocities.com/armaghan/
> >
>
> > ajeru <ajeru_at_my-deja.com> wrote in message news:84t9r6
> > $buh$1_at_nnrp1.deja.com...
> > > Hi,
> > >
> > > Does anyone have an idea how I can generate all the DDL statements
> > > necessary to recreate an existing oracle database. It's not only a
> > > backup problem. I need the SQL statements for documentation
reasons
> > > among other things. And the resulting create table statements
should
> > > include all the alter table statements made since the database was
> > first
> > > created.
> > >
> > > Thanks
> > >
> > > --
> > > Alexander Jerusalem
> > > Vienna Knowledge Net
> > > alexander.jerusalem_at_Xchello.at
> > > To mail me remove the X before chello
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> You can use a data modeling case tool to do the job.
> e.g. ERwin would allow you to reverse engineer an existing database
and
> from there, you can generate the required script.
>
> I'm sure some other data modeling tools would also have a similar
> feature.
>
> --
> Owais Anjum
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Jan 05 2000 - 09:36:11 CST
