You could use the query option. Buffer=64000
Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Les Hollis
[mailto:oracledba-ezmlmshield-x63135430.[Email address protected]
Sent: Tuesday, October 31, 2006 12:56 PM
To: LazyDBA Discussion
Subject: Re: Reorg Large table
how do you go about doing several smaller exports of the same table?
Are you setting your buffer size?
what about direct=y to bypass the sql and the parsing of the sql
----- Original Message -----
From: "Edwards Ed " <oracledba-ezmlmshield-x593548.[Email address
protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, October 31, 2006 9:49 AM
Subject: RE: Reorg Large table
> Are you using the "full" option of the export? If so, can you do
> several smaller exports?
>
>
>
>
>
> Please take a few minutes to provide feedback on the quality of
service
> you received. The Department of Education values your feedback as a
> customer. Commissioner John L. Winn is committed to continuously
assessing
> and improving the level and quality of services provided to you by
> Department staff. Simply use the link below. Thank you in advance for
> completing the survey.
>
>
> http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address
protected]
>
>
>
>
> -----Original Message-----
> From: Joel
> [mailto:oracledba-ezmlmshield-x16339067.[Email address protected]
> Sent: Tuesday, October 31, 2006 10:47 AM
> To: LazyDBA Discussion
> Subject: RE: Reorg Large table
>
> Huh?
>
> Joel Patterson
> Database Administrator
> joel.[Email address protected]
> x72546
> 904 727-2546
>
> -----Original Message-----
> From: ramon.[Email address protected]
> [mailto:oracledba-ezmlmshield-x67806481.[Email address protected]
> Sent: Tuesday, October 31, 2006 10:32 AM
> To: LazyDBA Discussion
> Subject: Re: Reorg Large table
>
>
>
> Hi,
>
> You can try to use the package RDBMS_REDEFINE
>
>
>
>>How do you reorg a rather large table (160million + rows) in a 9i
>>database.
>>Export / import seems to be an impractical approach (haven't
> been able
>>to get a successful export....fails for one reason or another
> after
>>multi-hours.)
>>Thanks in advance.
>>- Mark
>>DISCLAIMER:
>>This e-mail is for the intended recipient only.
>>If you have received it by mistake please let us know by
> reply and then delete it from your system; access, disclosure,
> copying, distribution or reliance on any of it by anyone else
> is prohibited.
>>If you as intended recipient have received this e-mail
> incorrectly, please notify the sender (via e-mail) immediately.
>>---------------------------------------------------------------------
>>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>>To post a dba job: <a
> href="/app/message?l=es&o=8&url=http%3A%2F%2Fjobs%2Elazydba%2Ecom"
> target="_blank">http://jobs.lazydba.com</a>
>>To Subscribe : <a
> href="/app/message?l=es&o=8&url=http%3A%2F%2Fwww%2ELazyDBA%2Ecom"
> target="_blank">http://www.LazyDBA.com</a>
>>To unsubscribe: <a
>
href="/app/message?l=es&o=8&url=http%3A%2F%2Fwww%2Elazydba%2Ecom%2Funsub
> scribe%2Ehtml"
> target="_blank">http://www.lazydba.com/unsubscribe.html</a>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page