DBAToolZ - Scripts ( Reverse Engineering ) DBAToolZ Home
 (Last updated 09/21/2006)
Home     Download     Forums     SQL Scripts     Book Review     Links     Feedback


Script Name Description

c_clone_grants.sql

	This script will "clone" SYS, OBJECT and ROLE level privs for any schema
	by creating a SQL script that can be used to copy these privs to another
	schema within the same database or a different database.
    

c_proc_extract.sql

	This script will extract source code for the following source types:
	1. PACKAGE
	2. PACKAGE BODY
	3. FUNCTION
	4. PROCEDURE
	The source code will be spooled into a file named after the source name

c_rebuild_synonyms.sql

	Reverse engineers synonyms (DB LINKS are supported)

c_tab_rec.sql

	Creates DDL script to re-create a table

c_tab_rec_plsql.sql

	Reverse Engineer Table DDL

c_tab_rec_plsql_all.sql

	Reverse Engineer Table DDL including
	constraints. Allows tablespace change for
	INDEXES generated by constraints and the
	TABLE it self. Doesn`t handle partitions.

c_tabsp_tmp_rebuild.sql

	This script rebuilds any LOCAL TEMPORARY tablespace
    

s_dbf_migrate.sql

	When migrating to a different host sometimes
	it is necessary to balance datafiles on new
	file systems to make sure you do not go over
	the available space.
	--
	For instance if your original host had 20GB
	file systems and your new host is only 12GB
	you can find this script very handy.
	--
	This script should be ran on the sourse instance
	before the migration.  It will display a line "---"
	when SUM of all datafiles reached the limit you
	specified

DBAToolZ Home | Contact Us
Copyright© 2001 DBAToolZ.com All Rights Reserved.