Re: Cloning 21 GB Table - Review Approach please

  • From: Alexander Gorbachev <gorbyx@xxxxxxxxx>
  • To: VIVEK_SHARMA@xxxxxxxxxxx
  • Date: Sat, 12 Mar 2005 14:50:54 +0100

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
--
//www.freelists.org/webpage/oracle-l

Other related posts: