Re: Help on partition managing

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 20 Jul 2002 10:35:54 +0200
Message-ID: <328iju0d6tq7hac1i4qto9rbdrr60vs6ao@4ax.com>

On Fri, 19 Jul 2002 17:05:26 GMT,
u705413818_at_spawnkill.ip-mobilphone.net (Joe Bayer) wrote:

>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
>
>
>

Your should NEVER EVER EDIT A DUMP file, you will get a *correct* series of statements when using the show=y log=<any filename> Why resorting to unsupported procedures of why you know they don't work?
Try using show =y or indexfile=<filename> and NEVER anymore vi a dump file.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jul 20 2002 - 03:35:54 CDT