Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help on partition managing
Hi Joe,
Not sure what your problem is ?
If you export a partitioned table, the export file *will* (or perhaps should in your case) contain the definition of the partitioned table. Are you sure you are using the 8.1.7 version of EXP to perform the export ?
I must say the fact you vi the export file kinda sends a shiver up my spine. You should *never* edit this file (or you will suffer the consequences my boy as my old headmaster used to say). May I suggest either an import with show=y or an import with indexfile=filename to see exactly what is defined for this table of yours. I say again, don't play around with the actual export file.
Good Luck
Richard
"Joe Bayer" <u705413818_at_spawnkill.ip-mobilphone.net> 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
>
>
>
>
>
>
> --
> 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
Received on Sun Jul 21 2002 - 06:21:27 CDT