Re: Reverse Engineering CREATE DATABASE scripts
From: Cor de Waaij <C.deWaaij_at_PTT-Telecom.NL>
Date: 1996/08/27
Message-ID: <4vusu4$fi4_at_hdxx05.telecom.ptt.nl>#1/1
Date: 1996/08/27
Message-ID: <4vusu4$fi4_at_hdxx05.telecom.ptt.nl>#1/1
Hi
In your on-going database:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE
In the trace file (location in your alert-file) is a use-ready
script to create your database again.
It's a very powerfull trick.
greetings Cor
In article <4usm5n$cuk_001_at_atlantis.nosc.mil>, rellison_at_nosc.mil (Richard Ellison) says:
>
>DBA's .....
>
>I want to reverse engineer the scripts needed to re-create existing databases
>in our 7.x environment. Has anyone written any PL/SQL scripts that meet this
>need? I'm considering exporting, recreating, and importing in the near
>future to deal with fragmentation issues.
>
>
>
Received on Tue Aug 27 1996 - 00:00:00 CEST