Re: parsing oracle DUMP file?

peter meulmeester wrote:
>
> Hello,
>
> I have a DMP file I would like to work with.
> I would like to scan it en create a separate files like tablename.sql
> which creates the table. same for views etc...
>
> Does anybody know of a tool or Perl script which does this?
>
> Also, I started hacking with Perl but encountered ^Z
> characters in the DMP. Perl then thinks "end of file". Is there a tool
> to get rid of these? Else I need to read in a binary mode and get rid of
> all the junk characters.
>
> And is there a format description of these dump files?
>
> best regards,
> Peter

imp show=y OR imp indexfile=

and then work with that file that results..

HTH

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

Its not the voices in my head that bother me... 
  its the voices in yours.