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