Using DATPROF Subset and subsetting a table with a Clob or Blob using a Uniqe Append is (much)  slower then tables without these dataypes.

Why is that?


DATPROF Subset adds the data to a table with unique append using a join to the Source table via the databaselink.

Oracle however, does NOT support the use of join through a databaselink on tables with Clobs or Blobs.

For that reason Subset first copies the whole source table to the Target environment.

When this table exist in the target it is used for the unique-append-join and then dropped.