Re: Extracting full DDL from

From: <>
Date: Thu, 15 May 2008 22:33:09 +0200
Message-ID: <>

On Thu, 15 May 2008 10:04:30 -0700 (PDT), Altus <> wrote:

>I need to generate the DDL for all packages in one schema. It has to
>be an executable file so it can be run with one command.
>SQL> @allpackage.sql
>select from dba_source... ;
> is lacking the final “/” and the beginning “CREATE OR REPLACE”
>Using DBMS_METADATA causes failures when the output is split across
>two chunks.
> ... from XYZ where pri_key_v <end of chunk>
><start of chunk>alue = 5;
>Does anybody have a clean way to produce this code?
>Oracle Enterprise on solaris 8. (yes, this box is old. We do
>have better for other apps.)

In my experience it boils down the classical settings for single column output

set heading off newpage 0 pagesize 0 feedback off -- for dbms_metadata
set long 100000000000000 (whatever big number) set linesize 132


Sybrand Bakker
Senior Oracle DBA
Received on Thu May 15 2008 - 15:33:09 CDT

Original text of this message