Home
Oracle DBA
Tips, Tricks and Utilities
1.
Script utility for extracting DDL from standard ORACLE exports. (From Oracle)
2.
Script to recompile invalid schema objects.
3.
Script to recompile schema objects.
4.
Script to build SQL*Loader CTL files.
5.1
Script to disable all non-SYS Primary Key, Unique, and Foreign Key constraints.
5.2
Script to enable all non-SYS Primary Key, Unique, and Foreign Key constraints.
6.1
Script to disable all non-SYS triggers.
6.2
Script to enable all non-SYS triggers.
7.
Script to drop ALL constraints for the current user.
8.
Script to drop ALL indexes for the current user.
9.
Script to drop ALL packages for the current user.
10.
Script to Truncate all non-sys tables in a database.
11.
Script to display a summary of blocking locks in a database.
12.
How to setup a StandBy database (Based on Oracle 8.1.7).
13.
SQL to display BAD indexes.
14.
KSH script to get the DB status
Oracle DBA Links
Statspack Viewer by Alexey B. Danchenkov
Jared Still's Oracle Utilities and Scripts
Stewart McGlaughlin's OraSnap Utility
Unix Utilities for DOS & Windows
Werner's Linux - Oracle Page
Poratls to Other sites
DBASupport.com
Floating frames are only available for IE 3.0 and above and Netscape 6 and above.
FastCounter by bCentral