Buffer=8192000
It should fly after you do this.
-----Original Message-----
From: Holder Mark
[mailto:oracledba-ezmlmshield-x15488804.[Email address protected]
Sent: Tuesday, October 31, 2006 1:15 PM
To: LazyDBA Discussion
Subject: RE: Reorg Large table
I'm trying to export a single table as follows;
file=i:\export\LMSP_Exp_audit_10272006.dmp
FULL=N
COMPRESS=Y
CONSISTENT=Y
STATISTICS=none
TABLES="LMS_PROD.AUDITENTRYBEAN"
log=i:\export\LMSP_Exp_audit_10272006.log
-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x593548.[Email address protected]
Sent: Tuesday, October 31, 2006 10:49 AM
To: LazyDBA Discussion
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
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: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
____________________________________________________________________
NOTICE: This email is intended only for the use of the party to
which it is addressed and may contain information that is privileged
confidential, or protected by law. If you are not the intended
recipient you are hereby notified that any dissemination, copying or
distribution of this email or its contents is strictly prohibited.
If you have received this message in error, please notify us
immediately by replying to the message and deleting it from your
computer.
Internet communications are not assured to be secure or clear of
inaccuracies as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses.
Therefore, we do not accept responsibility for any errors or
omissions that are present in this email, or any attachment, that
have arisen as a result of e-mail transmission.
____________________________________________________________________
Oracle LazyDBA home page