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%2Funsubscribe%2Ehtml"
target="_blank">http://www.lazydba.com/unsubscribe.html</a>



Oracle LazyDBA home page