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
Oracle LazyDBA home page