Re: Script to re-create views

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: Wed, 24 Mar 1999 15:53:44 +0100
Message-ID: <36F8FC78.55315198@psi.de>

The utility "reverse database engineer ..." which comes with the tool Hora 3 generates the DDL for the views (or the DDL for the tables or what you like). See http//www.keeptool.com for a free trial version of Hora 3. regards Jan Dieckmann

Julia Cristina Varela de Montoya wrote:

> Can anyone share to me a script to generate and re-create the views for
> a schema (or re-create in another database)? I think I can do it with
> SELECT 'CREATE OR REPLACE VIEW ' || VIEW_NAME || ' AS ' || TEXT || '/' FROM
> USER_VIEWS; but that seems simple and may I find problems with with it?
>
> Thank you very much.
Received on Wed Mar 24 1999 - 08:53:44 CST