Message-Id: <10748.127234@fatcity.com> From: "Peter Lomax" Date: Mon, 22 Jan 2001 09:24:57 +0200 Subject: Re: Exp/Imp eliminate table chained or migrated rows. This is a multi-part message in MIME format. ------=_NextPart_000_00A2_01C08455.2F897CC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good morning Chuan, Is this not the case with any data extraction and load tool? However IMHO is the question not how long is your row vs your blocksize. If your row does not depass your blocksize then Yes you could do this. However why not just run chained rows or migrated rows check. look at need_reorg.sql on our website. Regards Peter -- Peter Lomax =20 email: plomax@oriole.com=20 Oriole Corporation Voice: +44 (0) 7050-696-269=20 Fax: +44 (0) 7050-696-449=20 Performance Tools & Free Scripts ------------------------------------------------------------------ http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs ------------------------------------------------------------------ ----- Original Message -----=20 From: Chuan Zhang=20 To: Multiple recipients of list ORACLE-L=20 Sent: Monday, January 22, 2001 7:35 AM Subject: Exp/Imp eliminate table chained or migrated rows. Hi all, Has anyone got experience in whether the Exp/Imp can eliminate the = table chained or migrated rows? Your experience is much appreciated. Thanks in advance, Chuan=20 ------=_NextPart_000_00A2_01C08455.2F897CC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Good morning Chuan,

Is this not the case with any data = extraction and=20 load tool?

However IMHO is the question not how = long is your=20 row vs your blocksize.

If your row does not depass your = blocksize then Yes=20 you could do this.

However why not just run chained rows = or migrated=20 rows check.

look at need_reorg.sql on our = website.

Regards

Peter

--
Peter=20 Lomax &n= bsp; &nb= sp; &nbs= p;=20
email: plomax@oriole.com =
Oriole=20 Corporation
Voice: +44 (0) 7050-696-269=20
Fax: +44 (0) 7050-696-449 =
Performance=20 Tools & Free=20 Scripts
--------------------------------------------------------------= ----
http://www.oriole.com, designed by = Oracle DBAs=20 for Oracle=20 DBAs
-----------------------------------------------------------------= -

----- Original Message -----
From:=20 Chuan=20 Zhang
To: Multiple recipients of list = ORACLE-L=20

Sent: Monday, January 22, 2001 = 7:35=20 AM

Subject: Exp/Imp eliminate = table chained=20 or migrated rows.

Hi all,

Has anyone got = experience in whether=20 the Exp/Imp can eliminate the table chained or migrated = rows?

Your experience is much = appreciated.

Thanks in advance,

Chuan