Re: Scripts to re-create all elements

From: <mpir_at_compuserve.com>
Date: Wed, 10 Jun 1998 13:27:19 GMT
Message-ID: <6lm1jn$blc$1@nnrp1.dejanews.com>

If you do an export for the database with ROWS=N, just a definition of all the objects in the database will be generated.

Then if you do an import to an indexfile of the export file, an editable script to create all the objects in the database will be generated.

In article <qcZe1.516$7b5.1054634_at_weber.videotron.net>, "Robert Gauthier" <rogaut1_at_videotron.ca> wrote:
>
> Hi everyone,
>
> A need scripts to help me improve performance on Oracle and
> also scripts to recreate an entire table along with all (triggers,
> index..constraints...etc).
>
> Any contribution is welcome.
>
> Thanks !
>
> Rob
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 10 1998 - 08:27:19 CDT