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>
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
Problems:
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 9.2.0.8 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