Stack Overflow
Stack Overflow

Questions tagged [ora2pg]

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema.

48 questions
4
votes
1 answer

ora2pg out of memory error - after every table

when I try to export data, it runs out of memory, regardless of table size (even empty tables.) Out of memory! ] 162926/498508267 rows (0.0%) on total estimated data (14 sec., avg: 11637 recs/sec) Issuing rollback() due to DESTROY…
nycynik
  • 7,371
  • 8
  • 62
  • 87
3
votes
2 answers

how to install ora2pg on windows 7?

i downloaded the zip file which was available online for free download but i a not able to install the downloaded file and run the file, can any one please help me installing the ora2pg on my windows machine please.
Smithendu doddamane
  • 126
  • 1
  • 1
  • 5
2
votes
1 answer

collect2: fatal error: cannot find 'ld' when executing make install

I am migrating an Oracle Database to Postgres and I wanted to install orafce which is a module that contains some useful function which can help with the porting. I tried to execute the command "make install" but I got this error "collect2: fatal…
Massadi
  • 21
  • 1
  • 8
2
votes
0 answers

How to repair these errors related to environment variable?

I'm trying to migrate an oracle database to postgresql, I run the ora2pg command and i get these errors: root@ubuntu:~# ora2pg DBI connect('host=localhost;sid=XE;port=1521','HR',...) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var…
Khadhri Hamza
  • 330
  • 4
  • 16
2
votes
1 answer

How to export particular table schema and data using ora2pg migration?

I'm using ora2pg migration tool for migrate table schema and data from ORACLE database to Postgres Database. Using the following query, I can export the entire schema and data from the ORACLE database and Import the data into Postgres Database. To…
DineshDB
  • 5,998
  • 7
  • 33
  • 49
1
vote
1 answer

PostgreSQL User Defined Type Conversion from Oracle - CREATE TYPE AS TABLE OF

I've used ora2Pg to convert a PL/SQL procedure which uses a user-defined Oracle Object Types and corresponding Table Object Type. The Object Types and the Stored Procedure convert successfully and both install/compile successfully in PostgreSQL…
andrewtindle
  • 51
  • 2
1
vote
2 answers

Can I migrate a partitioned table to a non-partitioned table in Oracle with the CREATE TABLE statement?

I have an Oracle 11g partitioned table with 10 partitions for ten years of data, each on its own tablespace partitioned by range. Each year-partition contains 12 monthly-partitions. I would like to convert this table to a non-partitioned table,…
LBS
  • 518
  • 8
  • 17
1
vote
1 answer

Ora2pg - Export DDL to multiple files(table wise)

I am using ora2pg to migrate schema and data from oracle to postgres database. Is it possible to export DDL table wise? Currently it's exporting as one file with all the tables.
Udesh Sendanayake
  • 77
  • 2
  • 8
1
vote
1 answer

Install ora2pg [DBD::Oracle] manually on windows machine behind firewall no direct access to internet

I am trying o install ora2pg and followed ora2pg-on-windows I am stuck at perl -MCPAN -e "install DBD::Oracle" as my windows machine is behind a firewall and networking is not allowing this to open to it up to the internet. Is there a way to…
Developer
  • 33
  • 6
1
vote
0 answers

Running Ora2Pg with PostgreSQL 14

I've got PostgreSQL v14 server to migrate data from old Oracle server using ora2pg tool version 22.1. There is a problem when i try to execute ora2pg -c properties.conf, that gives me the following output: [========================>] 2/2 tables…
Squirrel
  • 45
  • 4
1
vote
1 answer

Oracle to_char numeric masking to postgres

I'm porting a procedure from Oracle to Postgres. In select of a query, I have TO_CHAR(v_numeric, '990.000') It seems, the same TO_CHAR(v_numeric, '990.000') works in Postgres with same result. Can someone please explain what the '990.000' in the…
Mano
  • 601
  • 10
  • 32
1
vote
0 answers

Custom Script Extension for Linux - Not able to run ora2pg command

I am new to Azure. We have created one small POC in which I need to select the VM name and Resource group name in which that VM is present. And then I need to mention the command which I need to execute and then click on execute button which will…
saurabh704
  • 63
  • 6
1
vote
2 answers

ora2pg - Strawberry perl - Can't load module Oracle.xs.dll

When i try to launch the following line : ora2pg -t SHOW_VERSION -c config/ora2pg.conf I get the following error : install_driver(Oracle) failed: Can't load 'C:\Strawberry\perl\site\lib/auto/DBD/Oracle/Oracle.xs.dll' for module DBD::Oracle:…
anais1477
  • 466
  • 1
  • 17
  • 36
1
vote
0 answers

Ora2pg export schema problems

I try to migrate from Oracle to PostgreSQL with ora2pg on Windows. When the migration template generated,I try to run export_schema script in perl. But .sh-expansion not supported. Change expansion to .pl and run this script leads to errors. How…
ivan
  • 11
  • 2
1
vote
2 answers

Ora2pg ALLOW and EXCLUDE directive not working

I am using ora2pg tool for database migration(oracle to PostgreSQL). I have to exclude some object from export, For that i have made changes accordingly in ora2pg config file(add comma separate list in exclude directive). But when i execute this…
Gourav Saklecha
  • 353
  • 2
  • 6
  • 15
1
2 3 4