Re: How to reverse engineer a database - to produce a SQLDDL using SQL*Plus only ?

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to reverse engineer a database - to produce a SQLDDL using SQL*Plus only ?

From: Nuno Guerreiro <nuno-v-guerreiro_at_telecom.pt>
Date: 1998/04/14
Message-ID: <3533796a.4558584@news.telecom.pt>#1/1

On Wed, 08 Apr 1998 17:09:15 +0100, Dominic Baines <rdab100_at_hermes.cam.ac.uk> wrote:

>I'm trying to recreate the SQLDDL used to create a database and it's
>objects. The database has been running for some time and there appear to
>be some sizing and I/O problems. I want to try to do some initail
>examination of this using a SQL script to create a SQLDDL of what is
>there now but a bit stuck trying to sort it out.

Study the Export utility supplied with the Oracle Server. I believe you can extract the commands to create tables and other objects, without extracting table data.

Good luck,

Nuno Guerreiro Received on Tue Apr 14 1998 - 00:00:00 CDT