Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 10g upgrade survey

RE: 10g upgrade survey

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Fri, 23 Mar 2007 07:18:48 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB306F0EE6B@x6009a.umb.corp.umb.com>


Single table or multiple tables? When we had to do 300G or so, we exported groups of tables at a time using 4 separate streams, and did the same on import. Took about 8 hours total for the whole thing. Of course, we didn't have many clobs, they can make things take a lot longer.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ujang Jaenudin Sent: Friday, March 23, 2007 6:00 AM
To: oracle-l_at_freelists.org
Subject: Re: 10g upgrade survey

hi,

could anyone have experience export/import about 250GB data? on SAN how long it takes. or is it better by dbua & cross platform transportable tablespace?

I will migrate oracle from win2k 64 bit oracle 9i non RAC to Linux 64 bit Oracle 10g RAC.

thanks for the reply

-- 
regards
ujang


On 3/21/07, Joel.Patterson_at_crowley.com <Joel.Patterson_at_crowley.com>
wrote:

>
> Yes, I agree. Would also point out some bugs that have been reported
on
> this forum. One was manual upgrades through 10.2.0.3 with datafiles
created
> back in eight. However, if you ask me, and you have the down time.
Moving
> things directly into Locally managed tablespaces now and getting it
overwith
> is worth it.
>
>
-- http://www.freelists.org/webpage/oracle-l ------------------------------------------------------------------------------ NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you. ============================================================================== -- http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 23 2007 - 07:18:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US