ora2pg
ora2pg copied to clipboard
darold
Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generate...
Reported by Hafiz, for example: ``` DECLARE c_id customers.id%type := &cc_id; c_name customerS.Name%type; c_addr customers.address%type; -- user defined exception ex_invalid_id EXCEPTION; BEGIN IF c_id
Hi Darold, During a direct import of data from Oracle to Postgres got the below error. While checked at the Oracle end found that this is a **nested table**. Is...
When i'm load data from one oracle partitioned table into postgres, the ora2pg (last version) execute transfer consequently for every partition of this table (i see it in session browser),...
Hi @darold Hope you and your loved one's are safe. We have been looking at enabling parallelism at partition level in Ora2Pg data load directly to PostgreSQL. This feature doesn't...
Hi, there is an option to convert all VARCHAR2 columns that are longer than let's say 200, so VARCHAR2(200) to TEXT instead of varchar? I've seen there is an option...
[feature request] Warning before connection to Oracle if output directory or output Postgresql database is not accessible. For directory if there is no write access rights or path not exist....
Got a real puzzler here. We've configured ora2pg to export an Oracle 12.2 table containing roughly 351 million records. The table contains 43 columns of the usual assortment of datatypes...
I am running Ora2pg migration assessment report, I want to exclude Synonyms from report. Is there any way we can exclude objects from report. Excluding objects during actual migration i...
Hi.. I am using ora2pg to export oracle table in postgresql. Created table should contains the fields of join to two different tables of Oracle. ## example ```txt REPLACE_QUERY NC_PROD_DLV_INFO[SELECT...
When i try to export from Oracle 11.2.0.4 into Postgres 11 overloaded package functions, for example: ``` create package pkg_bso procedure prc_export_bso_data; procedure prc_export_bso_data (p_task_id SAPP_TASK.TASK_ID%type); end package; ``` I've...