Help Center> Database and Application Migration UGO> FAQs> Product Consulting> Which Schemas in Source Databases Are Ignored for Migration?
Updated on 2024-04-22 GMT+08:00

Which Schemas in Source Databases Are Ignored for Migration?

Oracle as the Source Database Type

UGO does not collect the following schemas:

'APEX_050000', 'AUDSYS', 'ADAMS', 'ANONYMOUS',     
'AURORA$ORB$UNAUTHENTICATED', 'AWR_STAGE', 'APEX_030200', 'APEX_040200',   
'APEX_PUBLIC_USER', 'APPQOSSYS', 'BI', 'BLAKE', 'CLARK', 'CSMIG',
'CTXSYS', 'DBSNMP', 'DIP', 'DMSYS',
'DSSYS', 'DEMO','DVSYS', 'DVF',
'DBSFWUSER', 'EXFSYS','FLOWS_FILES',
'GGSYS', 'GSMADMIN_INTERNAL', 'GSMCATUSER','GSMUSER', 'HR',
'IX', 'JONES', 'LBACSYS', 'MDDATA', 'MDSYS','MGMT_VIEW',
'OE', 'OLAPSYS', 'ORACLE_OCM', 'ORDDATA', 'ORDPLUGINS',
'ORDSYS', 'OUTLN', 'OWBSYS', 'OWBSYS_AUDIT','OJVMSYS',
'PERFSTAT', 'PM', 'REMOTE_SCHEDULER_AGENT','SCOTT', 'SH',
'SI_INFORMTN_SCHEMA', 'SPATIAL_CSW_ADMIN_USR',    
'SPATIAL_WFS_ADMIN_USR', 'SYS', 'SYSMAN', 'SPATIAL_CSW_ADMIN_USR','SYSBACKUP',
'SYSKM', 'SYSDG', 'SYSRAC', 'SYS$UMF','SYSTEM',
'TRACESVR', 'TSMSYS', 'WMSYS', 'XDB', 'XS$NULL', 'GSMROOTUSER'

UGO does not collect the following tables:

System tables, for example, SYS_EXPORT_SCHEMA_ %

MySQL as the Source Database Type

  • information_schema
  • mysql
  • performance_schema
  • sys

PostgreSQL as the Source Database Type

  • information_schema
  • pg_catalog
  • pg_temp_1
  • pg_toast
  • pg_toast_temp_1
  • public

Microsoft SQL Server as the Source Database Type

  • guest
  • INFORMATION_SCHEMA
  • sys
  • db_owner
  • db_accessadmin
  • db_securityadmin
  • db_ddladmin
  • db_backupoperator
  • db_datareader
  • db_datawriter
  • db_denydatareader
  • db_denydatawriter

Product Consulting FAQs

more