Re: backup

Hi,

You can do it in a very simple way.

Write under SQL*Plus an SQL directed to a text file something like:

SQL> set spooler to 'filename'
SQL> select text from dba_source order by owner, name, type, line;
SQL> set spooler off

The output can be improved by you.

Any way, the source text of everything that you want is in the dba_source table.

George

"Sandy" <daleelaNOdaSPAM_at_usa.net.invalid> wrote in message news:0d8c11d0.b26c424a_at_usw-ex0110-076.remarq.com...
> hi,
>
> I would like to backup all the procedures,
> functions,packages i have made.
> How can i do ?
>
> thanks
>
> SAndy
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful Received on Sat Aug 26 2000 - 05:44:36 CEST