Oracle Developer Jr - READY TO HIRE! Next Step Systems US-CA-Thousand Oaks Post A Job | Post A Resume

• Create Schema Summary - This script will create a summary report of a schema pop (Added: 10-Sep-1999 Hits: 10620 Rating: 3.76 Votes: 8) Rate It

• Check table initial extent and next extent values - Use to check the database table initial extent and
  next extent value. (Added: 4-Jan-2001 Hits: 4912 Rating: 0 Votes: 0) Rate It

• Check UnAnalyzed Indexes for Analyzed Tables - This script will point out which indexes are not analyzed while the table has been analyzed (Added: 26-Feb-2001 Hits: 4610 Rating: 4.50 Votes: 2) Rate It

• Child Table Constraint Disable Script Generator - This script will give the statment of disable the Child tables if you know the Master table Name
  Run the script it will ask Master table Name (Added: 20-Sep-1999 Hits: 4303 Rating: 1.50 Votes: 2) Rate It

• CREATE Index for Foreign Keys whic are not already part of primary ke - This script will generate INDEX CREATION script for all table foreign keys when they are part of primary keys.
  
  This is usefull when you need to generate index for reference columns especially for DW applications. (Added: 19-Dec-2003 Hits: 3062 Rating: 0 Votes: 0) Rate It

• Database Maper - This script will map your database automatically. (Added: 13-Jul-2000 Hits: 8008 Rating: 6.50 Votes: 4) Rate It

• Database Objects by Type - Script to display the objects in the database by type (Added: 22-Sep-1999 Hits: 5743 Rating: 3.00 Votes: 2) Rate It

• Database Overview Re-released (NOTEMPFILES) - Gives database overview(all associated files), then gives tablespace breakdown on space followed by list of all objects contained within it, with storage parameters, room to extend {within current contiguous free space blocks available). (Added: 30-Sep-2003 Hits: 2676 Rating: 0 Votes: 0) Rate It

• Database Overview Re-Released (TEMPFILES) - Gives database overview(all associated files, tempfiles), then gives tablespace breakdown on space followed by list of all objects contained within it, with storage parameters, room to extend {within current contiguous free space blocks available). (Added: 30-Sep-2003 Hits: 2504 Rating: 0 Votes: 0) Rate It

• Database Storage Overview (NO Tempfiles) - Gives a complete breakdown of database files, tablespace storage overview information - together with extent sizes and 'room to extend' for each segment within each tablespace. Ends with summary on total size of database. [This script assumes you are not using temporary tablespaces utilising TEMPFILES] - Bear in mind, the PL/SQL loops will fall over if you have empty tablespaces! (I've not gotten round to circumventing this yet.) (Added: 10-Dec-2001 Hits: 4050 Rating: 0 Votes: 0) Rate It

Next 10