Extracting full DDL from
Date: Thu, 15 May 2008 10:04:30 -0700 (PDT)
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 220.127.116.11 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