Re: Schema installation tools

From: Andrew Allen <ajallen_at_mailhost.det.ameritech.net>
Date: Wed, 04 Sep 2002 10:19:59 GMT
Message-ID: <3D75DDE7.51C3A2B3_at_mailhost.det.ameritech.net>


Pasi Parkkonen wrote:
>
> Hi!
>
> I'm wondering what tools you use for generating scripts
> from your database. I need to do customer installations
> into bigger Oracle servers, so I will need good scripts.
>
> I have used Toad & my own script generators
> (SQL*Plus scripts) but they both have problems..
> Toad makes errors and well.. SQL*Plus ain't perfect... ;)
>
> So - what do you use for getting *everything* into script form:
> -Tables
> -Views
> -Table constraints (+ references)
> -Table data (in correct order when references present!)
> -Sequences (set to correct value!)
> -Indexes
> -Synonyms
> -Procedures & Functions
> -Triggers
>
> I'm not looking for the most "heavy" software,
> lightweight tool is cool :)
>
> Also - ER capabilities plus, not must.
>
> Thanks,
> Pasi Parkkonen

Try doing a full export setting the parameter ROWS=N. This will get you everything except the data.

-- 
Andrew Allen
Livonia, MI
E- Mailto:ajalle_at_ameritech.net
Received on Wed Sep 04 2002 - 12:19:59 CEST

Original text of this message