Situation
In Subset you have a Source and a Target Schema. They relate to the Database Source and Target user but are not the same.
The users might have access to several schemas.
Using Source User SRC1 you may have imported tables from Schema SRC1 and SRC2.
Using the Target user TGT1 you like to subset the data to two schemas. Because Subset is smart but not clairvoyant you are priovided with a list of schemas the user TGT1 has permissions for.
But: Is it correct that Subset for Oracle does not show all Schemas as targetschema?
Explanation
Yes you are correct
We obtain this data using the following query:
select distinct table_schema from all_tab_privs
union all
select user from dual
CODE
And from this liste we filter out the following schemas:
@aurora\$jis\$utility\ @aurora\$orb\$unauthenticated @ose\$http\$admin apex_ appqossys ctxsys dbsnmp dip dmsys exfsys flows_ lbacsys mddata mdsys mgmt_view | mtssys oaspublic odm odm_mtr olapsys omwb_emulation oracle_ocm orddata ordplugins ordsys outln owbsys owbsys_audit si_informtn_schema
| spatial_csw_admin_usr spatial_wfs_admin_usr sys sysman system toad tracesrv websys wk_proxy wk_test wksys wmsys xdb apex_public_user |