Re: database re-creation scripts
Date: 1997/10/28
Message-ID: <01bce381$78c209c0$54110b87_at_clamagent>#1/1
For $50 I'll send you a PL/SQL package that reverse-engineers an entire
schema. It generates syntactically correct DDL statements for existing:
Tables
Constraints (primary key/unique key/foreign key/check)
Secondary indexes (ones not related to constraints)
Views
Sequences
Synonyms
Grants
You can also specify each type of object separately if you only want to r-e
one type or one specific object.
You must compile it as SYS, then run it from SQL*Plus with set serveroutput on and spool to a file.
As a bonus I'll include a stored procedure that lets you see the index
definition for any table in any schema (also compiled as SYS).
Dan Clamage
1450 W. 116th Ave #25
Westminster CO 80234
Include your email address with your check or M.O.
dechaine <dechaine_at_MCIONE.com> wrote in article
<01bce152$cc54ab00$a4232299_at_frank>...
> I am trying to re-create my database's table creation scripts so that I
can
> build it up on a laptop using Personal Oracle. Somehow I've lost the
> original scripts and now am struggling to recover from this. I've spoken
to
> several people who say that it is possible to recreate these scripts via
> sql's but I am not proficient enough to figure it out myself .. I do not
> have developer or designer software so this is not an option. Does
anyone
> out there have any ideas or suggestions?
Received on Tue Oct 28 1997 - 00:00:00 CET