Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!k37g2000hsf.googlegroups.com!not-for-mail
From: Mark D Powell <Mark.Powell@eds.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Extracting full DDL from
Date: Fri, 16 May 2008 07:12:54 -0700 (PDT)
Organization: http://groups.google.com
Lines: 57
Message-ID: <6af615f8-f93f-42f4-81e9-28499a031791@k37g2000hsf.googlegroups.com>
References: <836b1673-7c74-4bb3-a860-52faa0030d42@l64g2000hse.googlegroups.com> 
 <mc7p24tja3s0vfitjoehmtuiqijhcguimt@4ax.com> <9D5Xj.2017$r82.289@nlpi069.nbdc.sbc.com>
NNTP-Posting-Host: 192.85.50.2
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1210947175 27909 127.0.0.1 (16 May 2008 14:12:55 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 16 May 2008 14:12:55 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: k37g2000hsf.googlegroups.com; posting-host=192.85.50.2; 
 posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET 
 CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Xref: usenetserver.com comp.databases.oracle.server:444685
X-Received-Date: Fri, 16 May 2008 10:12:55 EDT (text.usenetserver.com)

On May 15, 9:43=A0pm, Michael Austin <maus...@firstdbasource.com> wrote:
> sybra...@hccnet.nl wrote:
> > On Thu, 15 May 2008 10:04:30 -0700 (PDT), Altus
> > <silverb...@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... ;
> >> =A0 =A0 =A0 is lacking the final =93/=94 and the beginning =93CREATE OR=
 REPLACE=94
>
> >> Using DBMS_METADATA causes failures when the output is split across
> >> two chunks.
> >> =A0 =A0 =A0 ... from XYZ where pri_key_v <end of chunk>
> >> <start of chunk>alue =3D 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=3Ddatabase or item=3Dall... =A0you cou=
ld
> do the database, tables, procedures, etc... =A0 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.- Hide quoted text -
>
> - Show quoted text -

Oracle has definitely picked up some features and/or methods from RDB
but Oracle had a CBO before it purchased RDB.  It really came from
Ingres since Oracle hired the person behind the Ingres CBO to help
develop the CBO for version 7.0.  Also Oracle ported some of the
features of Oracle into RDB.  Oracle and DEC go way back so knowing
where any feature really came from is iffy at best.

IMHO -- Mark D Powell --