DBAToolZ - Scripts ( Utility ) DBAToolZ Home
 (Last updated 05/21/2003)
Home     Download     Forums     SQL Scripts     Book Review     Links     Feedback


Script Name Description

c_count_rec_1.sql

	Counts records in all tables in the database
	if specified so. Calls ctl_count_rec_2.sql
	creates TEMPORARY FILE --> record_cnt.tmp
	        OUTPUT    FILE --> record_count.out
	+----------------------------------------------------+
	|  Please Note that TABLES with UNDEFINED data type  |
	|  !!!!     will not work with this script     !!!!  |
	|      Make Sure To check For their exsistance       |
	+----------------------------------------------------+

c_count_rec_2.sql

	   ** DO NOT RUN THIS SCRIPT BY IT SELF **
	** This file is called by c_count_rec_1.sql **

c_db_bk_HOT.sql

	Generates and runs HOT back-up script
	backup`s one tablespace at a time

c_plan.sql

	This script prints execution plan for SQL which
	is already been explained in the PLAN_TABLE.

	It will list all available SQL statement ID from PLAN_TABLE
	and prompt you for the one you need to pring the explain plan for.

	To actually create an EXPLAIN PLAN for a SQL stmnt use the following:
	   SQL> explain plan
	   SQL> set statement_id = ``
	   SQL> for
	   SQL> 
	Before using explain plan you need to create PLAN_TABLE
	use ORACLE provided script for your platform ... RDBMS/ADMIN/UTLXPLAN.SQL

c_plan7.sql

	Purpose:
		q and d to execute explain plan (Oracle 7.3)
	Preparation:
	        Run $ORACLE_HOME/rdbms/admin/utlxplan.sql as SYSTEM
	        Create public synonym plan_table for plan_table
	        Grant all on plan_table to public
	        Create an index (id,parent_id) on plan_table

	Use:
	        Put the guilty SQL statement (with `,`) into a file called
	                target.sql
	        Start explain7.sql

	        The script displays the current audit id, then
	        the execution path, simultaneously writing the
	        execution path to a file identified by the audit id.

c_plan8.sql

	Purpose:
		q and d to execute explain plan (Oracle 8.0)
	Preparation:
	        Run $ORACLE_HOME/rdbms/admin/utlxplan.sql as SYSTEM
	        Create public synonym plan_table for plan_table
	        Grant all on plan_table to public
	        Create an index (id,parent_id) on plan_table

	Use:
	        Put the guilty SQL statement (with `,`) into a file called
	                target.sql
	        Start explain8.sql

	        The script displays the current audit id, then
	        the execution path, simultaneously writing the
	        execution path to a file identified by the audit id.

c_plan_script.sql

	Creates execution plan for a given SQL script

c_recomp_v7-8.sql

	Recompile all invalid objects.

c_recomp_v8i.sql

	Recompile all invalid objects including JAVA and TYPE.
	Allows compile of a single schema or all schemas.

c_tab_rec.sql

	Creates DDL script to re-create a table

s_tabsp_mig_local.sql

	This script will migrate a tablespace
	from DICTIONARY management to LOCAL

u_ascii.sql

	Prints ASCII table

u_autotrace.sql

	Creates PLAN table by running $ORACLE_HOME/rdbms/admin/utlxplan.sql
	sets AUTOTRACE ON (traceonly explain)

u_find_string.sql

	Searches for character string in all tables and views.

u_prompt.sql

	Chages SQL Prompt to "USER@INSTANCE_NAME:HOST_NAME> "

u_tab_data.sql

	Display table row in "vertical" format

u_tab_delete_commit.sql

	creates DELETE_COMMIT procedure developed by Oracle Support

u_tab_sqlldr_ctl.sql

	builds SQL*Loader control file for a table

u_tab_sqlldr_data.sql

	Formats table data for SQL*Loader

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