Re: generating scripts

Try using the exp / imp functions:

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

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 CDT