In Way1, I got different DDL or partial DDL. In Way2, I got only first 2 lines of Package body. I am running this command from Schema user only. Anyone knows how to achive this?]]>bsm.java2013-01-08T08:40:23-00:00Re: How to Export Package Body using Spool Commandhttp://www.orafaq.com/forum/./mv/msg/185643/574221/#msg_574221
regards,Delna]]>delna.sexy2013-01-08T08:51:50-00:00Re: How to Export Package Body using Spool Commandhttp://www.orafaq.com/forum/./mv/msg/185643/574222/#msg_574222
muralikri2013-01-08T08:53:11-00:00Re: How to Export Package Body using Spool Commandhttp://www.orafaq.com/forum/./mv/msg/185643/574223/#msg_574223
WAY2: set long 4000

WAY3: The first way points to the fact that there is another code repository. Keep it as the main one. Do not use database as your content version system (CVS) - it is not supposed to act so. Then, there will be no need to extract code from it anymore.]]>flyboy2013-01-08T08:55:25-00:00Re: How to Export Package Body using Spool Commandhttp://www.orafaq.com/forum/./mv/msg/185643/574233/#msg_574233
Regards
Michel
]]>Michel Cadot2013-01-08T09:41:28-00:00Re: How to Export Package Body using Spool Commandhttp://www.orafaq.com/forum/./mv/msg/185643/574302/#msg_574302
SET HEAD OFF
SET ECHO OFF
SET FEED OFF
SET TERM OFF
SET LINE 1500
SET NEWPAGE NONE
set pagesize 0
SPOOL C:\temp\SPI_xxx_PSPEC.SQL
PROMPT CREATE OR REPLACE
select trim(text) from user_source
where name='SPI_xxx_PCK' AND type='PACKAGE';
SPOOL OFF]]>bsm.java2013-01-09T02:00:09-00:00Re: How to Export Package Body using Spool Commandhttp://www.orafaq.com/forum/./mv/msg/185643/574325/#msg_574325