Re: Recreating the CREATE DATABASE DDLs

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 9 Jan 2009 10:17:50 -0700
Message-ID: <496794ce$1_at_news.victoria.tc.ca>


fitzjarrell_at_cox.net (oratune_at_msn.com) wrote:
: Comments embedded.

: On Jan 8, 5:54=A0pm, 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. =A0 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?

: DATABASE is not a valid object_type for DBMS_METADATA.GET_DDL.

My bad, I skimmed over the DATABASE keyword and in my mind read it as an unspecific description, like saying "ddl of things in the database".

That certainly answers the question of what is wrong with dbms_metadata.

Sorry, can't help. Received on Fri Jan 09 2009 - 18:17:50 CET

Original text of this message