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

From: Vikas Agnihotri <onlyforposting_at_yahoo.com>
Date: 23 May 2001 20:02:09 -0700
Message-ID: <77e87b58.0105231902.5a0e59db@posting.google.com>

nsouto_at_nsw.bigpond.net.au.nospam (Nuno Souto) wrote in message news:<3b0b91f4.5698330_at_news-server>...
> On 22 May 2001 07:58:43 -0700, onlyforposting_at_yahoo.com (Vikas
> Agnihotri) wrote:
>
> >Right, but INDEXFILE contains only CREATE TABLE/INDEX. I need all the
> >DDLs (create tablespace/user, grants, etc).
>
> I know you're gonna find this question weird, but:
>
> Can I ask, why?

Simply because I need the CREATE TABLESPACE, CREATE ROLLBACK SEGMENT statements. Since I am migrating to LMTs, I want to extract these DDLs and edit them to remove the DEFAULT STORAGE clause and add the EXTENT MANAGEMENT LOCAL clause.

(Ok, I really dont need the create role/user, etc. :-)

Vikas Received on Wed May 23 2001 - 22:02:09 CDT