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 |