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: Export Dump of of Large Table (Size = 200 GB) in 9.2 & Import into 10.2?

Re: Export Dump of of Large Table (Size = 200 GB) in 9.2 & Import into 10.2?

From: rjamya <rjamya_at_gmail.com>
Date: Wed, 21 Nov 2007 15:29:12 -0500
Message-ID: <9177895d0711211229o4f2c057du452ec6d3be361e05@mail.gmail.com>


Vivek,

  1. export each partition separately, when importing don't create indexes etc and do it yourself later on. see if you can di direct=y
  2. then id the table in 10g is similarly partitioned, you can run concurrent imports
  3. for splitting files, try exp help=yes

Raj

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 21 2007 - 14:29:12 CST

Original text of this message

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