Help on partition managing

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  

-- 
Sent by joebayerii from hotmail  within  area com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new