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: Cloning 21 GB Table - Review Approach please

Re: Cloning 21 GB Table - Review Approach please

From: Alexander Gorbachev <gorbyx_at_gmail.com>
Date: Sat, 12 Mar 2005 14:50:54 +0100
Message-ID: <c2213f6805031205501950c4e@mail.gmail.com> 





To generate some bases for test systems we are cloning the whole
schemas in this way:


INSERT /*+ PARALLEL(dst, 16) */ INTO dst
SELECT /*+ PARALLEL(src, 16) */ * FROM src;



> We are to clone a 32Million records table of approx 21GB in the same DB.....



-- 
Best regards,
Alex Gorbachev
--
http://www.freelists.org/webpage/oracle-l


Received on Sat Mar 12 2005 - 08:54:14 CST












Original text of this message













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