User uses Export Data Subset Wizard to export a subset of data from one schema to another. The data selected from tables to be exported is simply the top rows of the table. Is there an option to have export select rows randomly throughout the table?
WORKAROUND:
Manually modify the generated export script and add the SAMPLE function to the Select statement of each Insert statement as such:
From:
Insert /*+ PARALLEL(Dest, 4) APPEND */ into SCHEMA.TABLE Dest
Select /*+ FULL(SRC1) PARALLEL(SRC1, 4) */ *
from SCHEMA2.TABLE SRC1
Where rownum <= (select /*+ FULL(SRC2) PARALLEL(SRC2, 4) */
greatest(10, ceil((10/100) * count(*)))
from SCHEMA2.TABLE SRC2);
To:
Insert /*+ PARALLEL(Dest, 4) APPEND */ into SCHEMA.TABLE Dest
Select /*+ FULL(SRC1) PARALLEL(SRC1, 4) */ *
from SCHEMA2.TABLE SAMPLE (10) SRC1 <----Added SAMPLE function to extract 10%
Where rownum <= (select /*+ FULL(SRC2) PARALLEL(SRC2, 4) */
greatest(10, ceil((10/100) * count(*)))
from SCHEMA2.TABLE SRC2);
STATUS:
Enhancement request ER 34531 has been submitted to Development for consideration in a future release of Toad for Oracle.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy