Free Dynamic SQL-PL/SQL and Data Dictionary Utilities
From: Daniel Clamage <dclamageNOSPAM_at_telerama.com>
Date: Sat, 5 Dec 1998 01:56:10 -0000
Message-ID: <3668dad3.0_at_paperboy.telerama.com>
Stop by my web site to download free utilities:
* Reverse-engineer schema objects, generating syntactically correct DDL
Date: Sat, 5 Dec 1998 01:56:10 -0000
Message-ID: <3668dad3.0_at_paperboy.telerama.com>
Stop by my web site to download free utilities:
* Reverse-engineer schema objects, generating syntactically correct DDL
- A better put_line procedure that breaks the 255 barrier
- A better show error command that shows you the text along with the error message
- Run Explain Plans in one swell foop
- Dynamically grant/revoke object privileges for all objects of a given type to a given user
- List all indexes for a given table, with info on whether it represents a primary/unique constraint, what the columns are and their datatypes & sizes, and whether they are nullable
- Test an SQL/DML/DDL for syntactical correctness without actually executing it
- Scan indexes for a given table for corrupt blocks (yeah like that never happens)
Try them out and please email me if they prove useful.
-- - Dan Clamage http://www.telerama.com/~dclamage If you haven't crashed the Server, you haven't been trying hard enough.Received on Sat Dec 05 1998 - 02:56:10 CET