Performing a schema extraction v4
Schema extraction methods
You can perform a schema extraction using the EDB or Oracle extraction tools. For instructions and examples, see:
- EDB DDL Extractor (recommended method)
- Oracle Data Pump utilities
EDB recommends using the EDB DDL extractor to extract your schemas. Alternatively, you can use Oracle’s Data Pump (IMPDP/EXPDP) tool to export schemas from an Oracle database.
Warning
If you choose to extract schemas using a different method and then upload the DDL file to Migration Portal, the portal may not be able to assess the file correctly.
For more information, see Known issues, limitations, and notes.
Schemas and objects support
The lists and tables that follow show supported and unsupported schemas and objects in Migration Portal.
Unsupported schemas
Exclude these Oracle systems schemas while generating the SQL dump file.
| ANONYMOUS | APEX_PUBLIC_USER | APEX_030200 | APEX_040000 | APEX_040200 |
| APPQOSSYS | AUDSYS | CTXSYS | DMSYS | DBSNMP |
| DBSFWUSER | DEMO | DIP | DMSYS | DVF |
| DVSYS | EXFSYS | FLOWS_FILES | FLOWS_020100 | FRANCK |
| GGSYS | GSMADMIN_INTERNAL | GSMCATUSER | GSMROOTUSER | GSMUSER |
| LBACSYS | MDDATA | MDSYS | MGMT_VIEW | OJVMSYS |
| OLAPSYS | ORDPLUGINS | ORDSYS | ORDDATA | OUTLN |
| ORACLE_OCM | OWBSYS | OWBYSS_AUDIT | PDBADMIN | RMAN |
| REMOTE_SCHEDULER_AGENT | SI_INFORMTN_SCHEMA | SPATIAL_CSW_ADMIN_USR | SPATIAL_WFS_ADMIN_USR | SQLTXADMIN |
| SQLTXPLAIN | SYS$UMF | SYS | SYSBACKUP | SYSDG |
| SYSKM | SYSRAC | SYSTEM | SYSMAN | TSMSYS |
| WKPROXY | WKSYS | WK_TEST | WMSYS | XDB |
| XS$NULL |
Note
EDB Postgres Advanced Server doesn't support schema names starting with pg_.
Supported object types
- Tables
- Sequences
- Constraints
- Indexes (Except LOB indexes and indexes on materialized views)
- Synonyms
- Views
- Materialized views
- DB links
- Types and type body
- Triggers
- Functions
- Procedures
- Packages
- Users
- Roles
- Profiles
- Role and object grants
Note
COMMENTS on columns, tables, and materialized views are also supported.
Unsupported object types
- Editions
- Operators
- Schedulers
- LOB indexes and indexes on materialized views
- XML schemas
- Tablespaces
- Directories
- RLS policy
- Queues *
- Library
- Indextype
* Even though EDB Postgres Advanced Server provides support for Queue tables, Migration Portal does not currently support it. Queue tables in the source DDL are not uploaded as source and target DDL objects.