Unix scripts to extract DDL from imp show=y

I have some scripts that I wrote to do the following :

read through an 'indexfile=???' file and extract each index and table with it's tablespace into a 'mapfile'.
Then read through another 'indexfile=???' file removing all the REMs from the table creation scripts, and changing the tablespace names to match those in the mapfile to create a new 'schema' creation script.

If these sound useful (and they are in AWK) then email me direct for a copy - they might need modification, but there is good documentation with them :o)

They were used so that a database which had been created 'wrongly' by a consultant could be compared against a 'correct' one and a rebuild cortrectly script generated. It works for un-partitioned tables & indexes only so should be ok for O7 and O8, provided the partitioning option hasn't been taken advantage of.

Regards,
Norman.

PS. Just noticed, you have 'full=y' whereas mine have been tested on a user level dump file.

Norman Dunbar		EMail:	NDunbar_at_LynxFinancialSystems.co.uk
Database/Unix administrator	Phone:	0113 289 6265
Lynx Financial Systems Ltd.	Fax:	0113 201 7265
			URL:	http://www.LynxFinancialSystems.com


------------------------------------------------------------------------

-----Original Message-----
From: onlyforposting_at_yahoo.com (Vikas Agnihotri) [mailto:onlyforposting_at_yahoo.com]
Posted At: Tuesday, May 22, 2001 4:05 AM Posted To: server
Conversation: Unix scripts to extract DDL from imp show=y Subject: Unix scripts to extract DDL from imp show=y

Can someone please point me to some awk/sed scripts to extract DDL from the 'imp full=y show=y' output?

Metalink has a Perl script to do this, but i dont have Perl on my system. Plain awk/sed scripts would be perfect.

Thanks Received on Tue May 22 2001 - 02:26:36 CDT