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

Nuno Souto wrote:
>
> 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?
>
> Cheers
> Nuno Souto
> nsouto_at_bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html

Its useful for re-creating most (but not all) of a database. In any event, my preference is to run 'strings' on an 'exp rows=n' rather than the indexfile - it avoids all that nasty stuff with line's wrapping - each ddl is on a single (long) line.

Its good for adding things like new storage, new tablespaces, NOLOGGING or PARALLEL etc to index/constraint commands.

CHeers
Connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"