Hi,

Sorry, the package name is DBMS_REDEFINITION and with it you
can reorganize tables on-line.

In my customer, we are using it to recreate big tables with a
high number of inserts and deletes.

In Metalink, you can see, how this package works Note:177407.1

Regards

>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"><a
href="/app/message?l=es&o=8&url=http%3A%2F%2Fjobs%2Elazydba%2Ecom%3C%2Fa%3E"
target="_blank">http://jobs.lazydba.com</a></a>
>>To Subscribe : <a
>href="/app/message?l=es&o=8&url=http%3A%2F%2Fwww%2ELazyDBA%2Ecom"
>target="_blank"><a
href="/app/message?l=es&o=8&url=http%3A%2F%2Fwww%2ELazyDBA%2Ecom%3C%2Fa%3E"
target="_blank">http://www.LazyDBA.com</a></a>
>>To unsubscribe: <a
>href="/app/message?l=es&o=8&url=http%3A%2F%2Fwww%2Elazydba%2Ecom%2Funsub
>scribe%2Ehtml"
>target="_blank"><a
href="/app/message?l=es&o=8&url=http%3A%2F%2Fwww%2Elazydba%2Ecom%2Funsubscribe%2Ehtml%3C%2Fa%3E"
target="_blank">http://www.lazydba.com/unsubscribe.html</a></a>
>---------------------------------------------------------------------
>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>
>---------------------------------------------------------------------
>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