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



Oracle LazyDBA home page