Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Execution time for export/import vs. alter table move tablesp
Just listened to a talk by Kevin Loney (noted Oracle author). Table-table
data movement (alter table move) is the fastest way to move data in Oracle.
How much faster depends on your system. My experience says twice as fast is
a safe guess. Cost justifying an upgrade?? What ogres do you work for?
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Friday, October 26, 2001 2:55 PM
To: Multiple recipients of list ORACLE-L
tablespace command
I am doing a cost justification for upgrading a data warehouse from 8.0.4 to 8.1.7.
I need to submit it today and don't have time to do a test on a very large table.
Does anyone have anecdotal evidence or experience in the time difference required to reorg a tablespace using the export/import table method versus alter table move to a new tablespace method?
Thanks for any time quotes you can provide. I'm especially interested in very large tables and tablespaces.
Thanks,
Cherie Machler
Oracle DBA
Gelco Information Network
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Cherie_Machler_at_gelco.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 26 2001 - 14:02:50 CDT
![]() |
![]() |