Re: Script to re-create views

From: Stuart Browning <stuartb_at_embarcadero.com>
Date: Thu, 25 Mar 1999 15:07:55 -0800
Message-ID: <7deff7$5n7$1@news.ncal.verio.com>

Embarcadero DBArtisan can reverse-engineer any Oracle database subset into ordered script files. It can also create HTML-based object reports, migrate schema and data between instances and much more.

You can download a free 30 day evaluation at http://www.embarcadero.com/products/dbartisan/artisan.htm

Regards,
Stuart Browning
Embarcadero

Dr. Jan Dieckmann wrote in message <36F8FC78.55315198_at_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 Thu Mar 25 1999 - 17:07:55 CST