Once you have accessed your schema with 100% success, you can export the script using EXPORT DDL. You may choose any of the following options to deploy the script and populate data, including:
Execute the script in an on-premises database to create objects. Verify objects in schema and on successful verification, move data from Oracle to EDB Postgres using EDB Migration Toolkit.
Transport and execute exported script in database on EDB Postgres Ark instance to create objects. (EDB Postgres Ark is a DBaaS for hybrid cloud deployments of Postgres to public and private clouds; on Amazon, Azure, OpenStack, and other deployment platforms) . Verify objects in schema and on successful verification, move data from Oracle to EDB Postgres using EDB Migration Toolkit. EDB Migration Toolkit allows data migration in both Online and Offline mode, so you may migrate data in offline mode and then transport data files to Ark instance and execute this file in PEM or EDB-PSQL to populate objects.
Following is the example to use EDB-PSQL to deploy the exported DDLs for schema HR:
-copyViaDBLinkOra module The dblink_ora module provides Advanced Server-to-Oracle connectivity at the SQL level. A dblink_ora is bundled and installed as a part of the Advanced Server database installation. The dblink_ora utilizes the COPY API method to transfer data between databases. This method is considerably faster than the JDBC COPY method.