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: <JApplewhite_at_austinisd.org>
Date: Fri, 23 Mar 2007 09:47:20 -0500
Message-ID: <OF812F1DB9.F37DFBA5-ON862572A7.0050707B-862572A7.00513BF2@austinisd.org>


Yes, "Divide and Conquer" when doing Exports/Imports is a very good strategy. Our Student Information System has over 127,000 tables (yes, that's One Hundred Twenty-Seven Thousand), representing seven SchoolYears' of data. We use SQL statements to dynamically create an Export *.par file for each SchoolYear and export them in parallel. It's only about 30G of data, but parallelizing the process has greatly speeded up the refresh of our Dev and other databases with selected SchoolYears'.

As Andrew points out, having LOBs or not impacts the Export times. I would add that the degree of constraints and/or indexing greatly impacts the Import times.

BTW, we've found that the Tables= list in the Export *.par fiile can be somewhere just short of 32,000 before Export barfs.

Our environment is predominantly Oracle9i on Linux and HPUX.

Jack C. Applewhite - Database Administrator Austin (Texas) Independent School District 512.414.9715 (wk) / 512.935.5929 (pager)

 Same-Day Stump Grinding! Senior Discounts!

"Kerber, Andrew W." <Andrew.Kerber_at_umb.com> Sent by: oracle-l-bounce_at_freelists.org
03/23/2007 08:05 AM
Please respond to
Andrew.Kerber_at_umb.com

To
ujang.jaenudin_at_gmail.com, oracle-l_at_freelists.org cc

Subject
RE: 10g upgrade survey

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




--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 23 2007 - 09:47:20 CDT

Original text of this message

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