DDL::Oracle / News: Recent posts

DDL::Oracle has been stable for the last several releases. All planned features are included, and the project is deemed to be of production quality.

DDL::Oracle has been updated to produce DDL for Oracle 7.3 and 8.0 databases for the following:

TABLES
INDEXES
TABLESPACES

Program defrag.pl now does an ANALYZE TABLE/INDEX after the import for objects which were previously analyzed. It also has been revised to handle tables containing '$' in their names. Some changes for robustness have been made, such as verifying that log directories are writeable before file creation. And a few bugs were squashed.

Release 0.23 now ready for download. It has significant performance improvements.

Actually, they're not significant. Rather they are MAJOR performance improvements -- 2 or 3 orders of magnitude on large databases.

One functional bug is fixed in this release -- the REBUILD of unusable indexes following a defrag of a tablespace with partitioned objects was not working, but now is (we think).

And we were inadvertantly adding a blank line to Trigger text, and that is now fixed.... read more

Oracle.pm and defrag.pl have reached Beta stage. All features planned for this stage have been implemented and put through integration testing. We are looking for testers to put the software through rigorous tests on as many platforms and instances as possible.

If you use defrag.pl, ddl.pl or just DDL::Oracle as a standalone tool, please let us know what your experiences were (good, bad or indifferently) so that we can fix what is broken as well as report any successes.... read more

A good week! Release 0.19 is now available for downloading.

Program defrag.pl is ready for some serious beta testing, but please review the logs between each step. It now has one of the 2 proposed methods for handling partitions. The second method is under construction, and should be in the next release. In addition, shell scripts are now provided to ease executing the various export, import and sql files. This also ensures that logs are created for each file.... read more

Defrag script "defrag.pl" now included. This is the first release of this program, so caution is advised. In this version, partitioned tables are defraged only if all partitions/subpartitions reside in the named tablespace. The next release will support partition exchanges and resizing of all partitions within in named tablespace. Also included in the distribution is a README file. Please do. It contains instructions for reporting bugs and highlights the Open Discussion forum available here at SourceForge. Please let me know about your successes and failures -- together we can make this a very useful tool.

Well, a nice warm broth, maybe.

DDL::Oracle is advancing nicely, and is now considered usable by its author.

It includes the RESIZE method for both tables and indexes. It also includes all of the primary object types for the CREATE method, namely:

CONSTRAINT
DATABASE LINK
FUNCTION
INDEX
PACKAGE
PROCEDURE
PROFILE
ROLE
ROLLBACK SEGMENT
SEQUENCE
SYNONYM
TABLE
TABLESPACE
TRIGGER
TYPE
USER
VIEW

In addition, it includes the object type TABLE FAMILY, which produces the DDL to create the table(s) along with the(ir) Comments (table & column), Constraints, Indexes and Triggers all in one call to DDL::Oracle.... read more

The module is deemed to be of Alpha quality. It certainly isn't finished, but it's usable. It includes CREATE TABLE/INDEX for regular and partitioned objects, and ALTER TABLE/INDEX for resizing.

Also included is ddl.pl, a rudimentary interface to the module without any programming.

Please report bugs to the Bug List, and send any comments to the Gemeral Discussion forum.

Thanks!

Version 0.04 of DDL::Oracle.pm has been placed in the SourceForge CVS tree, and is downloadable. This is a very preliminary version, but has the "resize" functionality operational.