Re: Recreating the CREATE DATABASE DDLs
Date: 9 Jan 2009 10:17:50 -0700
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)
: > 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?
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