在对oracle为数据源做迁移的时候,不选择的用户(owner)列表

SELECT OWNER,TABLE_NAME
FROM DBA_TABLES
WHERE OWNER NOT IN ('APEX_050000','AUDSYS','ADAMS','ANONYMOUS','AURORA$ORB$UNAUTHENTICATED',
'AWR_STAGE', 'APEX_030200','APEX_040200','APEX_PUBLIC_USER','APPQOSSYS',
'BLAKE','CLARK',' CS MIG','CTXSYS','DBSNMP','DIP','DMSYS','DSSYS',
'DEMO','DVSYS','DVF','DBSFWUSER','EXFSYS','FLOWS_FILES','GGSYS',
'GSMADMIN_INTERNAL','GSMCATUSER','GSMUSER','JONES','LBACSYS','MDDATA',
'MDSYS','MGMT_VIEW','OLAPSYS','ORACLE_OCM','ORDDATA','ORDPLUGINS',
'ORDSYS','OUTLN','OWBSYS','OWBSYS_AUDIT','OJVMSYS','PE RFS TAT',
'REMOTE_SCHEDULER_AGENT','SI_INFORMTN_SCHEMA','SPATIAL_CSW_ADMIN_USR',
'SPATIAL_WFS_ADMIN_USR','SYS','SYSMAN','SPATIAL_CSW_ADMIN_USR','SYSBACKUP',
'SYSKM','SYSDG','SYSRAC','SYS$UMF','SYSTEM','TRA CES VR','T SMS YS',
'WMSYS','XDB','XS$NULL','GSMROOTUSER')

 

posted @ 2025-07-15 16:43  咻_python  阅读(10)  评论(0)    收藏  举报