Re: generating scripts

From: The Siebrands <siebrand_at_bigpond.com>
Date: 2000/06/27
Message-ID: <N7165.1187$c5.4515_at_newsfeeds.bigpond.com>#1/1

Try using the exp / imp functions:

Firstly export the database: exp / file=<schema.dmp> \ rows=n constraints=y indexes=y grants=y \ direct=y owner=<schema>
Import the file using the indexfile option imp / file=<schema.dmp> \ contraints=y grants=y indexes=y \ indexfile=<schema.out>
Edit the s<schema.out> file, this has all of the indexes, grants, create [Quoted] table, crea views, stored procedure, etc

[Quoted] SP <spant1_at_aol.com> wrote in message
news:ZXS55.415$0x.13764_at_nuq-read.news.verio.net...
> How can I generate scripts of all or any of the objects in a database?
>
>
Received on Tue Jun 27 2000 - 00:00:00 CEST

This message: [ Message body ]
Next message: Randy DeWoolfson: "Re: generating scripts"
Previous message: Jerry Gitomer: "Re: generating scripts"
In reply to: SP: "generating scripts"
In reply to SP: "generating scripts"
Next in thread: Randy DeWoolfson: "Re: generating scripts"
Reply: Sylvain Faust: "Re: generating scripts"
Reply: ddf_dba_at_my-deja.com: "Re: generating scripts"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message