results: 73456,015625
-----Original Message-----
From: Les Hollis
[mailto:oracledba-ezmlmshield-x58592773.[Email address protected]
Sent: Tuesday, October 31, 2006 1:37 PM
To: LazyDBA Discussion
Subject: Re: Reorg Large table
guess i should have said (even though it should go without saying)
IN sqlplus run this script
select sum(bytes)/1024/1024 from dba_segments where segment_name =
'LMS_PROD.AUDITENTRYBEAN';
----- Original Message -----
From: "Holder Mark "
<oracledba-ezmlmshield-x15488804.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, October 31, 2006 12:14 PM
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
>
>
---------------------------------------------------------------------
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.
Oracle LazyDBA home page