Re: obtaining ddl from a binary dump file

From: Lionel Mandrake <nobody_at_nospam.nowhere.nohow>
Date: Thu, 12 Jul 2001 02:39:49 GMT
Message-ID: <V5837.127365$mG4.63359915@news1.mntp1.il.home.com>

Specify full=y and indexfile=file_to_hold_the_ddl as parameters to imp. That will dump the ddl into the file without actually importing it.

HTH. "Maurice Samuels" <samuels_at_blue.seas.upenn.edu> wrote in message news:9ii0i0$bgb$1_at_netnews.upenn.edu...
> does anyone know of any scripts (unix, specifically Solaris 2.7) that will
read an Oracle export dmp file
> (binary) and obtain the table/index ddl (specifically for partitioned
objects), and where i can get them?
> thanks in advance
> -maurice
> samuels_at_seas.upenn.edu
>
> ps. --> personally i would just use import to get the ddl but some other
dba's prefer to just get it from
> the dmp file (go figure?).
>
Received on Wed Jul 11 2001 - 21:39:49 CDT