Oracle DBA's module for Oracle 8i, 8.0 and 7.3. Reverse engineers DDL for specified list of objects. Defrags entire tablespaces. Resizes tables/indexes to your standards. Creates user X with privileges of Y. Etc., etc., etc.
Be the first to post a text review of DDL::Oracle. Rate and review a project by clicking thumbs up or thumbs down in the right column.
Added configure method attribute 'grants', which optionally adds GRANT statements to the CREATE <object> DDL for those object types having GRANTs. Previously, GRANTs were generated from the GRANTEE perspective, which was less than helpful. This change corrects this problem. The default is to exclude them. Added configure method attribute 'storage', which optionally excludes the STORAGE clause as well as the PCT_FREE, PCT_USED, INITRANS and MAXTRANS clauses. The default is to include them. Added configure method attribute 'tblspace', which optionally excludes the TABLESPACE clause from DDL for tables and indexes. The default is to include it. Note: the 'storage' and 'tblspace' options were suggested by DBA Mark Proctor, whose developers import DDL::Oracle generated project DDL into their own schemas [which have individually configured object sizing and default tablespaces]. Thank you, Mark! Fixed bug #425876 regarding the CREATE SCHEMA, and the schema name in various objects. Fixed bug #426596 regarding CREATE TRIGGER statements with the UPDATE OF <column[s]> attribute. Note: These two bugs were previously fixed in patch #427911. Fixed bug #445871 submitted by Richard Michaud regarding Foreign Key constraints which referenced a table in a different schema. Thanks Richard! Implemented a bug fix submitted by Michael Talarczyk having to do with a sporadic condition in column DEFAULT values. Thanks, Michael!
Added configure method attribute 'grants', which optionally adds GRANT statements to the CREATE <object> DDL for those object types having GRANTs. Previously, GRANTs were generated from the GRANTEE perspective, which was less than helpful. This change corrects this problem. The default is to exclude them. Added configure method attribute 'storage', which optionally excludes the STORAGE clause as well as the PCT_FREE, PCT_USED, INITRANS and MAXTRANS clauses. The default is to include them. Added configure method attribute 'tblspace', which optionally excludes the TABLESPACE clause from DDL for tables and indexes. The default is to include it. Note: the 'storage' and 'tblspace' options were suggested by DBA Mark Proctor, whose developers import DDL::Oracle generated project DDL into their own schemas [which have individually configured object sizing and default tablespaces]. Thank you, Mark! Fixed bug #425876 regarding the CREATE SCHEMA, and the schema name in various objects. Fixed bug #426596 regarding CREATE TRIGGER statements with the UPDATE OF <column[s]> attribute. Note: These two bugs were previously fixed in patch #427911. Fixed bug #445871 submitted by Richard Michaud regarding Foreign Key constraints which referenced a table in a different schema. Thanks Richard! Implemented a bug fix submitted by Michael Talarczyk having to do with a sporadic condition in column DEFAULT values. Thanks, Michael!
Be the first person to add a text review.
Copyright © 2010 Geeknet, Inc. All rights reserved. Terms of Use
Thanks for your rating!
Would you also like to write a review?
Thanks for your review!
Get credit for your review by logging in via OpenID. Click your account provider: