Re: [GENERAL] Oracle to PostgreSQL Migration.

On Mon, May 29, 2017 at 7:17 PM, Adrian Klaver wrote: > On 05/29/2017 06:40 AM, PAWAN SHARMA wrote: > >> >> > ya, but how can fix it.?? >> >> because memory is not an issue on both the server. >> >> >> Hi Chris, >> >> I am able to get the output script in

Re: [GENERAL] Oracle to PostgreSQL Migration.

On 05/29/2017 06:40 AM, PAWAN SHARMA wrote: ya, but how can fix it.?? because memory is not an issue on both the server. Hi Chris, I am able to get the output script in output.sql but now data migration is the big problem.

Re: [GENERAL] Oracle to PostgreSQL Migration.

>>> >>> >> ya, but how can fix it.?? >> >> because memory is not an issue on both the server. >> > I've never used ora2pg but there is some documentation saying that often an out of memory issue can be fixed by adjusting your DATA_LIMIT setting.

Re: [GENERAL] Oracle to PostgreSQL Migration.

On Mon, May 29, 2017 at 6:54 PM, PAWAN SHARMA wrote: > > > On Mon, May 29, 2017 at 6:51 PM, Chris Mair wrote: > >> [>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec) >>> [>] 1/2 total rows (50.0%) - (4 sec.,

Re: [GENERAL] Oracle to PostgreSQL Migration.

On Mon, May 29, 2017 at 6:51 PM, Chris Mair wrote: > [>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec) >> [>] 1/2 total rows (50.0%) - (4 sec., avg: 0 >> recs/sec). >> Out of memory!] 1/2 rows (50.0%) on total estimated

Re: [GENERAL] Oracle to PostgreSQL Migration.

[>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec) [>] 1/2 total rows (50.0%) - (4 sec., avg: 0 recs/sec). Out of memory!] 1/2 rows (50.0%) on total estimated data (4 sec., avg: 0 recs/sec) Issuing rollback() due to DESTROY without explicit

Re: [GENERAL] Oracle to PostgreSQL Migration.

On Mon, May 29, 2017 at 6:28 PM, Chris Mair wrote: > C:\ora2pg>ora2pg -c ora2pg.conf >> [>] 2/2 tables (100.0%) end of scanning. >> [>] 0/2 tables (0.0%) end of scanning. >> [>] 2/2 tables (100.0%) end of

Re: [GENERAL] Oracle to PostgreSQL Migration.

C:\ora2pg>ora2pg -c ora2pg.conf [>] 2/2 tables (100.0%) end of scanning. [>] 0/2 tables (0.0%) end of scanning. [>] 2/2 tables (100.0%) end of table export. Looks good so far. This means you could connect to Oracle DB now.

Re: [GENERAL] Oracle to PostgreSQL Migration.

On Mon, May 29, 2017 at 2:49 PM, Chris Mair wrote: > I am facing below issue while running below command. >> >> *C:\ora2pg>ora2pg -c ora2pg.conf* >> DBI connect('host=;sid=;port=',',...) >> failed: ORA-01017: invalid username/p >> assword; logon denied (DBD ERROR:

Re: [GENERAL] Oracle to PostgreSQL Migration.

I am facing below issue while running below command. *C:\ora2pg>ora2pg -c ora2pg.conf* DBI connect('host=;sid=;port=',',...) failed: ORA-01017: invalid username/p assword; logon denied (DBD ERROR: OCISessionBegin) at C:/Strawberry/perl/site/lib/Ora2Pg.pm line 1376. FATAL: 1017 ... ORA-01017:

Re: [GENERAL] Oracle to PostgreSQL Migration - Need Information

On Wed, Jul 8, 2015 at 5:20 PM, Joshua D. Drake j...@commandprompt.com wrote: On 07/08/2015 12:47 PM, John McKown wrote: ​Why are they converting? Would EnterpriseDB (a commercial version of PostgreSQL which has extensions to make it a drop in replacement for Oracle) be a possibility?

Re: [GENERAL] Oracle to PostgreSQL Migration - Need Information

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Le 08/07/2015 22:25, CS DBA a écrit : On 07/08/2015 02:20 PM, John R Pierce wrote: On 7/8/2015 1:16 PM, dinesh kumar wrote: We recently done the similar migration for one of our customer. We used all opensource tools to achieve this migration

Re: [GENERAL] Oracle to PostgreSQL Migration - Need Information

Hi, We recently done the similar migration for one of our customer. We used all opensource tools to achieve this migration process. We used Pentaho Data Integration tool for doing Online DB migration, which took minimal downtime with CDC{Change Data Capture} approach. Also, we used Ora2Pg tool

Re: [GENERAL] Oracle to PostgreSQL Migration - Need Information

On 7/8/2015 1:16 PM, dinesh kumar wrote: We recently done the similar migration for one of our customer. We used all opensource tools to achieve this migration process. We used Pentaho Data Integration tool for doing Online DB migration, which took minimal downtime with CDC{Change Data

Re: [GENERAL] Oracle to PostgreSQL Migration - Need Information

On 07/08/2015 12:47 PM, John McKown wrote: ​Why are they converting? Would EnterpriseDB (a commercial version of PostgreSQL which has extensions to make it a drop in replacement for Oracle) be a possibility? http://www.enterprisedb.com/solutions/oracle-compatibility-technology Because EDB

Re: [GENERAL] Oracle to PostgreSQL Migration - Need Information

On 07/08/2015 02:20 PM, John R Pierce wrote: On 7/8/2015 1:16 PM, dinesh kumar wrote: We recently done the similar migration for one of our customer. We used all opensource tools to achieve this migration process. We used Pentaho Data Integration tool for doing Online DB migration, which

Re: [GENERAL] Oracle to PostgreSQL Migration - Need Information

This is almost exactly what we did around 8 years ago; obviously the version numbers have changed. The reason we chose Postgres was the enormous similarity between the two languages plus the overwhelming ROI on the migration; my CEO had a spontaneous nosebleed when the Oracle licensing costs were

Re: [GENERAL] Oracle to PostgreSQL Migration - Need Information

On Wed, Jul 8, 2015 at 1:20 PM, John R Pierce pie...@hogranch.com wrote: On 7/8/2015 1:16 PM, dinesh kumar wrote: We recently done the similar migration for one of our customer. We used all opensource tools to achieve this migration process. We used Pentaho Data Integration tool for doing

Re: [GENERAL] Oracle to PostgreSQL Migration - Need Information

On Wed, Jul 8, 2015 at 2:24 PM, Tim Clotworthy tclotwor...@bluestonelogic.com wrote: Hello, I have a customer that is about to undertake a migration of an Oracle 11g database to PostgreSQL 9.x (exact version to be determined). I am talking not only of the migration of schemas and data, but

Re: [GENERAL] Oracle to PostgreSQL Migration - Need Information

I would start by looking at how many databases, schemas, tables and views are involved. Then look at how many individual Oracle functions need to be converted to plpgsql. You also need to investigate if there are any custom data types. I do not have the formula, but I am sure there is a general

Re: [GENERAL] Oracle to PostgreSQL migration

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I think that's been part of pgadmin 2 On Monday 08 December 2003 10:49 pm, Randy Harris wrote: I've been scouring the PostgreSQL web site and have found several references to a Database Migration Wizard. I was unable, however, to find any