Re: Unix scripts to extract DDL from imp show=y

From: Vikas Agnihotri <onlyforposting_at_yahoo.com>
Date: 22 May 2001 10:23:57 -0700
Message-ID: <77e87b58.0105220923.4f8623f@posting.google.com>

onlyforposting_at_yahoo.com (Vikas Agnihotri) wrote in message news:<77e87b58.0105211904.bad5e05_at_posting.google.com>...
> 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.

Oracle 8.1.7 comes with Apache, Perl, etc. So I tried it out...

Heh! The Perl script posted on Metalink is totally broken. It extracts just the first line of every CREATE statement. Received on Tue May 22 2001 - 12:23:57 CDT