Re: Recreating the CREATE DATABASE DDLs

From: fitzjarrell_at_cox.net <oratune_at_msn.com>
Date: Fri, 9 Jan 2009 07:10:21 -0800 (PST)
Message-ID: <91a711d8-8834-4da3-8821-944ce5d27fc5_at_h41g2000yqn.googlegroups.com>


Comments embedded.

On Jan 8, 5:54 pm, yf..._at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:
> bhd282 (benjamin.i.do..._at_gmail.com) wrote:
>
> : Is it possible to regenerate database DDLs as one can do with
> : dbms_metadata.get_ddl? or with some scripts that can pull the
> : information from the dictionaries?
> : I have the SQL saved of the original CREATE DATABASE and ALTER
> : DATABASE statements when using DBCA.   I'd like to be able to see the
> : exact definition of the database without resorting to saving every
> : ALTER DATABASE statement that I execute.
> : (I've found a useful SQL statement online, that will generate the
> : CREATE TABLESPACE statements.)
> : -b
>
> What is wrong with dbms_metadata.get_ddl itself?

[Quoted] DATABASE is not a valid object_type for DBMS_METADATA.GET_DDL.

>
> It has various options to get the dll to create many types of objects, not
> just tables.  

It won't, however, return the DDL to create a database.

David Fitzjarrell Received on Fri Jan 09 2009 - 16:10:21 CET

Original text of this message