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


Oracle LazyDBA home page