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

From: Vikas Agnihotri <onlyforposting_at_yahoo.com>
Date: 22 May 2001 07:58:43 -0700
Message-ID: <77e87b58.0105220658.1a596472@posting.google.com>

nsouto_at_nsw.bigpond.net.au.nospam (Nuno Souto) wrote in message news:<3b0a403d.4398169_at_news-server>...
> On 21 May 2001 20:04:35 -0700, onlyforposting_at_yahoo.com (Vikas
> Agnihotri) wrote:
>
> >Can someone please point me to some awk/sed scripts to extract DDL
> >from the 'imp full=y show=y' output?
>
> It would be easier from an INDEXFILE file, rather than show=y.

Right, but INDEXFILE contains only CREATE TABLE/INDEX. I need all the DDLs (create tablespace/user, grants, etc). Only 'exp/imp full=y' provides this.

Thanks. Received on Tue May 22 2001 - 09:58:43 CDT