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@LIFE       To:     Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>     
                    TOUCH.COM>            cc:                                          
                           
                    Sent by:              Subject:     RE: Execution time for 
export/import vs. alter table move  
                    [EMAIL PROTECTED]        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.
[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).




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

Reply via email to