Toad Data Subset  : Script not generated correctly for tables with self_reference constraints< (4327214)

The problem is that when a table has a self referencing constraint, the insert statement generated (when <100% data is selected) is not correct.  The select statement (inside the insert statement) is using a join to the newly created table, which does not have any data, so it will always have zero rows of data.  The script should generate a valid insert statement in these cases.

Product Defect

WORKAROUND:

Add a where clause that select number of rows based on row count.  Below is an example.

eg.
  insert into dpaulus2.tt1
  select *
  from   dpaulus.tt1
  where  rownum <= N; -- N is the number to be updated to percentage of the total row that are intended to export.

STATUS:

Waiting for a fix in a future release of TOAD for Oracle.