Re: imp table data, but not PK indexes?

I have been using it on HP and it speeds up export with direct=y. I wish HP should enhance this value greater than 65535 as it is maximum limit on HP. It helped me in export when we were changing block size from 4K to 16K

Regards
Rafiq

From: "Tanel Poder" <tanel.poder.003_at_mail.ee> Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: Re: imp table data, but not PK indexes? Date: Sun, 20 Jul 2003 09:14:30 -0800

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

Never in production. But once I was writing a paper on upgrading databases with low downtime, then I tested this parameter on NT (or was it linux?) workstation and saw difference big enough to conclude, that this parameter may be useful.

Tanel.

>
>
> > 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
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Nuno Souto
> INET: nsouto_at_optusnet.com.au
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
   INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.