RE: Reorg Large table

RE: Reorg Large table

 

  

No, I did not put the comma in, it was part of the results, which I
interpeted as a decimal point.

So, the answer is 73,456.015625 MB or 75.456 GB (gigabytes)...which I
believe to be about right (it contains over 160 million rows).

- Mark

-----Original Message-----
From: Les Hollis
Sent: Wednesday, November 01, 2006 1:21 PM
To: Holder, Mark
Subject: Re: Reorg Large table

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text


did you put that one comma in there?

If so then I am assuming that the ouptput of the script running says
that you have 73456015625 MB in that one table. Roughly 73 PETA Bytes If
that is the case, then the chances of you exporting a 73PB table is
non-existent.


AND YES Mukaarram Shah I am aware of what the script will tell me. I
was enquiring as to the total size of the table.




----- Original Message -----
From: "Holder Mark "
[Email address protected]
To: "LazyDBA Discussion" [Email address protected]
Sent: Tuesday, October 31, 2006 12:49 PM
Subject: RE: Reorg Large table


> 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.
>
>
> ---------------------------------------------------------------------
> 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