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 "
<oracledba-ezmlmshield-x13706210.[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
>
>


Oracle LazyDBA home page