Re: Extracting full DDL from
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Thu, 15 May 2008 20:43:57 -0500
Message-ID: <9D5Xj.2017$r82.289@nlpi069.nbdc.sbc.com>
>
>
> 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
>
>
> hth
Date: Thu, 15 May 2008 20:43:57 -0500
Message-ID: <9D5Xj.2017$r82.289@nlpi069.nbdc.sbc.com>
sybrandb_at_hccnet.nl wrote:
> On Thu, 15 May 2008 10:04:30 -0700 (PDT), Altus
> <silverback_at_photobooks.com> 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 >> >> 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.)
>
>
> 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
>
>
> hth
10g and 11g have a few more tools akin to the Oracle/Rdb (formerly DEC/Rdb) command : rmu/extract/item=database or item=all... you could do the database, tables, procedures, etc... or just let it create the whole thing...
Alas, Oracle/Rdb is where Oracle RDBMS got most all of it's new features like partioned and locally managed, autoextend autoallocate tablespaces not to mention the CBO. Received on Thu May 15 2008 - 20:43:57 CDT