Re: imp table data, but not PK indexes?

From: Nuno Souto <nsouto_at_optusnet.com.au>
Date: Mon, 21 Jul 2003 01:05:41 +1000
Message-Id: <25968.338593@fatcity.com>

• Original Message ----- From: "Tanel Poder" <tanel.poder.003_at_mail.ee>

> 2) export data with constraints=n rows=y indexes=n direct=y
> recordlength=65535

  ^^^^^^^^^^^^^^^^^^

Do you find that makes a real difference? I haven't had much success with it...

> Also, if you plan to shorten your downtime by first exporting/importing the
> structure from online database and then transferring data during downtime,
> you have to worry about your sequences, because they have probably
> incremented after structure export and data export. Thus a simple script has
> to be done for that (thanks John ;).

Good point, thanx!

>
> Tanel.

Cheers
Nuno Souto
nsouto_at_optusnet.com.au Received on Sun Jul 20 2003 - 10:05:41 CDT