Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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