Hi All,
Is there any possibility to export a particular procedure and the same thing in import.
pls let me know if there is any possibility.
Printable View
Hi All,
Is there any possibility to export a particular procedure and the same thing in import.
pls let me know if there is any possibility.
Cant export a specific package, but you could look in dba_source to get the code and spool the output out e.g.
set head off
set feedback off
set pages 1000
spool package.sql
select text from dba_source where name ='PACKAGE NAME';
spool off
Thanx for ur instant reply, i understand it,,,
My question is can i use the export and import utility in this issue.
Pls explain me.
Quote:
Originally posted by fraze
Cant export a specific package,
as far as I know - No you can't export one specific package/procedure etc
Thanx for ur valuable answer.