Re: generating scripts

SQL-Programmer IX does that, "a la carte". Multiple objects, multiple servers, schema... you deside.

PC Week Analyst choice Award, SQL-Programmer

Free Download of SQL-Programmer:
http://www.sfi-software.com

...and we SUPPORT our customers!

Sylvain Faust
SFI
http://www.sfi-software.com

> -----Original Message-----
> From: Matt B. [SMTP:mcb_at_fightspam.sd.znet.com]
> Posted At: Tuesday, June 27, 2000 12:57 AM
> Posted To: tools
> Conversation: generating scripts
> Subject: Re: generating scripts
>
> "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?
>
> Use TOAD or SQL*Station.
>
> Or from SQL*Plus:
>
> set pagesize 0 heading off feedback off trimspool on linesize 2000 (or
> any
> reasonably large number) echo off
>
> spool myfile.sql
> select text
> from dba_source
> where owner = nvl(&the_owner_you_want,owner)
> and name = nvl(&the_object_you_want,name)
> order by owner, name, type, line;
> spool off
>
> You might still need to clean up the "spool off" from your output file
> as well
> as the original spool command.
>
> -Matt
>
Received on Thu Jun 29 2000 - 00:00:00 CEST