Re: Disable redo writing

From: Slim Dave <slimdave_at_yahoo.com>
Date: Tue, 1 Feb 2011 06:02:16 -0800 (PST)
Message-ID: <268843.50228.qm_at_web30803.mail.mud.yahoo.com>

Can you not use tablespace transport instead of datapump? No logging, no index rebuilding.

• Original Message ----
  > From: Yechiel Adar <adar666_at_inter.net.il>
  > To: ORACLE-L <oracle-l_at_freelists.org>
  > Sent: Thu, 27 January, 2011 8:14:32
  > Subject: Disable redo writing
  >
  > I am moving a database from 10.2 to 11.1.0.7 on Linux Red HAT EE 5.
  >
  > I built a new database and I want to use IMPDP with network link to copy the
  >data.
  >
  > I have 2 problems:
  >
  > 1) How I can disable redo writing during the initial copy?
  > I heard there is an hidden parameter for this.
  > If you know about it and think that it is too dangerous to put on the
  >list, please send it directly to me.
  >
  > 2) Index building is done one index at a time. How I can cause it to work in
  >IMPDP in parallel?
  > I already run the impdp with sqlfile for index and constraint, but i want
  >it to run in impdp.
  >
  > TIA
  >
  > Yechiel
  > --
  > http://www.freelists.org/webpage/oracle-l
  >
  >
  >
  

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 01 2011 - 08:02:16 CST