Re: Recreating the CREATE DATABASE DDLs
Date: Fri, 9 Jan 2009 07:10:21 -0800 (PST)
On Jan 8, 5:54 pm, 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. 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 won't, however, return the DDL to create a database.
David Fitzjarrell Received on Fri Jan 09 2009 - 16:10:21 CET