Re: Recreating the CREATE DATABASE DDLs
Date: 8 Jan 2009 16:54:51 -0700
bhd282 (benjamin.i.doyle_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.)
What is wrong with dbms_metadata.get_ddl itself?
It has various options to get the dll to create many types of objects, not just tables. I find it useful to skip the attributes that aren't part of the logic of a table.
(DBMS_METADATA.SESSION_TRANSFORM,'SEGMENT_ATTRIBUTES',false); Received on Thu Jan 08 2009 - 17:54:51 CST