Re: How to export stored procedure
From: Steve Long <answers_at_ix.netcom.com>
Date: 1996/06/04
Message-ID: <4p1tv4$t12_at_dfw-ixnews9.ix.netcom.com>#1/1
Date: 1996/06/04
Message-ID: <4p1tv4$t12_at_dfw-ixnews9.ix.netcom.com>#1/1
In <31B37D08.148C_at_itsi.disa.mil> Bob Yeh <yehr_at_itsi.disa.mil> writes:
>
>Hi,
>
>I am trying to move stored procedures from one user to another. EXP
does
>not have the option to export just that. What can I do?
>
>Bob.
Bob,
I wrote this SQL*Plus script on the fly, test it out:
set echo off feedback off verify off head off pagesize 0 lines 65
SPOOL output.pls
select
text
from
dba_source
where
owner = upper('&USER') -- or use a literal here order by
line
group by
type
,name
/
SPOOL off
exit
Received on Tue Jun 04 1996 - 00:00:00 CEST