Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Backup stored procedures
On Wed, 11 Jun 2003, NetComrade wrote:
> exp owner=owner rows=n
> will export all DDL and procs/functions/packages/triggers
> it'll take seconds.
Thank you.
Hanne
-- Hanne Midttun http://www.tihlde.org/~hannem No! Try not. Do. Or do not. There is no try. - YodaReceived on Thu Jun 12 2003 - 02:00:10 CDT
> On Wed, 11 Jun 2003 14:42:27 +0200, Hanne Iren Midttun
> <hannem_at_tihlde.org> wrote:
>
> >Hi,
> >is it possible only to backup stored procedures using the exp utilty?
> >eg exp user/password
> > file=file.dat
> > log=log.log
> > owner=owner
> > tables=user_source
> >
> >regards Hanne
> >--
> >Hanne Midttun
> >http://www.tihlde.org/~hannem
> >
> >No! Try not. Do. Or do not. There is no try. - Yoda
> >
>
> .......
> We use Oracle 8.1.7.4 on Solaris 2.7 boxes
> remove NSPAM to email
>