Use Easydump for Oracle at http://www.wangz.net,
it can extract all object's ddl from a dmp file without
doing an import.
u705413818_at_spawnkill.ip-mobilphone.net (Joe Bayer) wrote in message news:<l.1027098326.1057342529@[64.94.198.252]>...
> Hi, we are using oracle 8172
>
> I used to use export with rows=n to get the dump file, and vi the dump
> file, after delete the first few lines, we can get the table re-create
> script.
>
> But if the table is partitioned, when I open the dump file with vi, I
> can not see any table re-create script even if I deleted all the lines,
> is there any way I can get the ddl of a table?
>
> When we user create table bla as select * from table A, what I got is
> unpartitioned tables, is there any convinent way to create a copy of a
> partitioned, sub-partitioned table?
>
>
> Thanks for your help
Received on Mon Jul 22 2002 - 22:06:48 CDT
