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. [EMAIL PROTECTED]
-----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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).