Re: How to export a package and a procedure
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: nileshkum@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Sun, 15 Jul 2007 23:26:33 -0700
Here is something i have been using for the last few years with
good results (pulled this one from asktom long ago .. worth its
weight in gold)
$ more getcode_all.sql
set heading off
set feedback off
set linesize 100
set trimspool on
spool getcode_all.out
select [1]'@getcode ' || object_name
from user_objects
where object_type in ( 'PROCEDURE', 'FUNCTION', 'PACKAGE' )
/
spool off
set heading on
set feedback on
set linesize 130
set termout on
@getcode_all.out
$ more getcode.sql
set feedback off
set heading off
set termout off
set linesize 1000
set trimspool on
set verify off
spool &1..sql
prompt set define off
prompt set echo off
select decode( type||'-'||to_char(line,'fm99999'),
'PACKAGE BODY-1', '/'||chr(10),
null) ||
decode(line,1,'create or replace ', '' ) ||
text text
from user_source
where name = upper('&&1')
order by type, line;
prompt /
prompt set define on
prompt set echo on
spool off
set feedback on
set heading on
set termout on
set linesize 100
HTH
GovindanK
On Sat, 14 Jul 2007 02:56:15 +0530, "nilesh kumar" <nileshkum@xxxxxxxxx>
said:
Hello All,
I have an issue i need to export a package and a procedure too
which is present in another package , is there any solution
for this in datapump or exp utility.Or is there any other
solution for this to do pls help , i am using 9i and 10g both
.
Thanks
Nilesh soni
References
1. mailto:'@getcode
Other related posts:
