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
Dennis,
Cost-justifying bringing in an outside resource to perform the required QA
test
cycle. There is no money or resource currently to do that. Otherwise,
we'll have
to wait until next year when they can bundle the QA effort for the Oracle
upgrade
in with the next release cycle of our product.
It's kind of weird that the QA schedule and priorities here drive almost
all of
the other schedules and projects.
Thanks for your reply. On a personal note, are you at the Lifetouch in Eden Prairie?
Cherie Machler
Oracle DBA
Gelco Information Network
DENNIS WILLIAMS <DWILLIAMS_at_LIFE To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> TOUCH.COM> cc: Sent by: Subject: RE: Execution time for export/import vs. alter table move root_at_fatcity.co tablesp m 10/26/01 03:10 PM Please respond to ORACLE-L
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 Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
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 Liststo: 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:56:19 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |