Life made easier : Scripts to Extract DDL from Export DUMP

From: Som Priani <spriani_at_noida.hcltech.com>
Date: Thu, 2 Nov 2000 18:41:51 -0000
Message-Id: <10668.120951@fatcity.com>

Hi Listers,

Scenario : Build a test/play database from an export dump from Production (those monstrous sizes) but do not have disk space to accomodate all the extents...

Rummaging through the dump file and/or precreating tablespaces and objects and then importing the rest is the solution!! Even if all the SQL scripts are available - running them in the order of dependency will be quite tedious and error prone.

I have created Korn shell scripts to extract the DDL for objects which need disk space in the database and then to reduce them by a factor or set them to a fixed value. Please find them at http://members.tripod.com/Som_Priani The strategy

        Create a new database

	Extract the SQL scripts from the export dump using the utility
	Resize file and extent sizes ( the editing has been automated )

	CREATE TABLESPACES
	CREATE ROLLBACK SEGMENTS
	CREATE PROFILES
	CREATE USERS
	CREATE ROLES
	GRANT SYSTEM PRIVS to USERS
	REVOKE SYSTEM GRANTS /ALTER users
	CREATE TABLES
	CREATE INDEXES
	Import with IGNORE=Y to get all the constraints, stored programs,

triggers...

Takes a few minutes to run the whole thing - try it out... Bouquets and Brickbats welcome!! Please use backchannel. Received on Thu Nov 02 2000 - 12:41:51 CST