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.

s_db_seg_where.sql

	THIS Script reports table or index extent maping by datafile.

s_ind_col.sql

	Reports indexes, indexed columns for a table

s_tab_chain_row.sql

	This script will show the RowIDs for all chained rows
	this will allow you to quickly see how much of a problem chaining
	is in each table. If chaining is prevalent in a table, then that table
	should be rebuild with a higher value for PCTFREE
	--
	PCTFREE - tells the database how much space should be kept FREE IN EACH
	          DATA BLOCK. This space is then used when rows that are already
	stored in the data block extent in length via UPDATEs.
	--
	Before running this script you need to analyze all tables in the database
	to detect and record chained rows in tables:
	--
	SQL> analyze table  list chained rows into CHAINED_ROWS,
	--
	CHAINED_ROWS table must be created before "analyze"
	/rdbms/admin/UTLCHAIN.SQL to create it

s_tab_const.sql

	Reports all constraints for a given table or owner

s_tab_figure_subparts.sql

	I use this script on tables that are not yet
	partitioned but need to be partitioned.
	It allows me to figure out number of subpartitions.
	--------
	STRATEGY:
 	+------------------------------------------+
 	Goal:
 	        20 EXTENTS per SUBPARTITION
 	Rule:
 	        2sp     for 0-40        EXTENT TABLE
 	        8sp     for 41-160      EXTENT TABLE
 	        16sp    for 161+        EXTENT TABLE
 	+------------------------------------------+

s_tab_part.sql

	Reports partitioned tables from dba_part_tables

s_tab_subpart.sql

	Reports table subpartition details

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