Oracle RDBMS - administration, tools, scripts, and opinions...

Here’s the paper Gene King and I presented at Oracle OpenWorld ’98 and IOUG-A Live! '99:

• Deriving Test Data from a Production Database - the paper – a zipped word document
• Deriving Test Data from a Production Database - the slides – a zipped powerpoint slide presentation
• The Unabridged IOUG-A Live! '99 version- includes all the source code. The official version and the slides are available at http://www.ioug.org

Scripts!

Here are some scripts that you might find useful. If i can come up with some more I'll start a new page. These first five come from the paper above.

• ana_all.sql - analyze all the tables/indexes for a user. You might want to modify it based on your non-uniformly distributed columns.
• compile_all.sql - compile all the objects owned by a user.
• drop_all.sql - drop all of the objects owned by a user. DANGEROUS!
• enacon.sql - enable all the constraints in a schema (three times in case the dependencies are not in alphabetical order.
• enacon_except.sql - one pass at enabling constraints, with exceptions into the exceptions table.

Some useful Oracle-related sites:

• www.oracle.com - Oracle's home page
• support.oracle.com/metalink - Oracle Metals support page - if you have a CSI#, check this out!
• www.oramag.com - oracle magazine, subscribe!
• http://www.lazydba.com - home of the oracle dba mailing list! also starting a scripts section.
• http://www.adela.sk/kuzela/OWSKiller/ - i haven't tried it yet, but it is interesting...