Extracting full DDL from

From: Altus <silverback_at_photobooks.com>
Date: Thu, 15 May 2008 10:04:30 -0700 (PDT)
Message-ID: <836b1673-7c74-4bb3-a860-52faa0030d42@l64g2000hse.googlegroups.com>

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.) Received on Thu May 15 2008 - 12:04:30 CDT

Original text of this message