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