Re: extracting DBA_SOURCE and recreating (HELP!)

Bob Manieri <bmanieri_at_ford.com> wrote:

>tlp_at_redrockgrp.win.net (Tracy Lynn Pendergast) wrote:
>> I'm trying to write a procedure to extract source code
>> for such things as packages to produce the ability of
>> recreating them...
>> for some reason the extracted code compiles with
>> "compilation errors". Originally I had the problem of
>> source lines being cut off... I've been manipulating
>> linesize (and getting full lines of code) but still
>> receiving the same compilation error...
>--
>Tracy:
>On Oracle Corp's RTSS Bulletin Board are several PL/SQL routines for
>reverse engineering DDL for various database objects, tables, indexes
>,triggers, procedures etc. You might find these useful.
>If you're looking for routines that do indexes, views, and tables
>these can be done in straight SQL. Very useful when going against
>an old V6 database. Yes, there are one or two still out there.

Are they available to the Internet Community (http, ftp) ?

>Hope this helps.
>========================================================================
> Bob Manieri, Database Administrator, Ford Electronics, Lansdale, PA
> SELECT 'These are my opinions and not those of my employer.'
> FROM SYSTEM.DUAL WHERE DISCLAIMER = 'YES' ;