Re: Generate SQL DDL?

From: Eoin Woods <Eoin_at_copse.demon.co.uk>
Date: Tue, 1 Nov 1994 17:08:08 +0000
Message-ID: <783709688snz_at_copse.demon.co.uk>


In article <tlandrum.2.2EB0302F_at_kbsi.com>, Tom Landrum <tlandrum_at_kbsi.com> wrote:
>
>In Oracle, is there any way to generate the SQL DDL for an existing database?
Check out the book:

	"Oracle 7.0 Administration and Management", Michael R. Ault,
		Wiley-QED, 1994, ISBN 0-471-60857-2.

It has a number of useful utilities which derive DDL for tables and indexes from the system catalogue - these would be a useful starting point for a complete "DDL Recovery" system.

Eoin.

-- 
Eoin Woods, LBMS Plc, Evelyn House, 62 Oxford Street, London W1N 9LF, UK
            Tel: +44-71-636-4213  Email: Eoin_at_copse.demon.co.uk
            Fax: +44-71-66-2708      or  E.Woods_at_ieee.org
          "When do we start newsgroup comp.os.emacs ? :-)"
      These are my opinions - don't blame my employer for them!
Received on Tue Nov 01 1994 - 18:08:08 CET

Original text of this message