Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Reverse engineer CREATE DATABASE sql

Re: Reverse engineer CREATE DATABASE sql

From: joel garry <joel-garry_at_home.com>
Date: 31 Jul 2006 14:04:24 -0700
Message-ID: <1154379864.421876.278270@m79g2000cwm.googlegroups.com>

carkbster_at_gmail.com wrote:
> I've seen various scripts out there that can extract the CREATE
> DATABASE SQL for an existing SID, but most seem to be limited to
> version 8.1 or below.
>
> Has there been any newer scripts to extract the SQL for Oracle 10g
> databases?
>
> -Crispin

Metalink Note:1039149.6 and Note:211905.1 have some interesting ideas, though I don't know how 10ish they are. I just tried the script on an XE beta db and it seems to have worked.

jg

--
@home.com is bogus.
And the number 3 selling game was:
http://www.signonsandiego.com/uniontrib/20060731/news_mz1b31game.html
Received on Mon Jul 31 2006 - 16:04:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US