Re: [GENERAL] Migrating data from Oracle 9i to PostgreSQL

2006-04-05 Thread Mikael Carneholm
We have used the pro*c program found in this discussion (for the exact same purpose): http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:45902 0243348 It is *blazingly* fast, and creates CSV formatted files suited perfectly for postgresql's COPY command. Dumping 40Gb of data, sendi

[GENERAL] Migrating data from Oracle 9i to PostgreSQL

2006-04-04 Thread krokodylek
Hi :-) I sure hope I'm asking in the right place... Is there any automated or semi-automated way of migrating data from Oracle database (9.2.0.4) to PostgreSQL one? I only need the data, nothing else (not stored procedures, indexes, etc.), the relations are pretty simple, for example: CREATE

Re: [GENERAL] Migrating data from Oracle 9i to PostgreSQL

2006-04-04 Thread Thomas Pundt
Hi, On Tuesday 04 April 2006 14:01, [EMAIL PROTECTED] wrote: | I sure hope I'm asking in the right place... | | Is there any automated or semi-automated way of migrating data from Oracle | database (9.2.0.4) to PostgreSQL one? | | I only need the data, nothing else (not stored procedures, indexes,

Re: [GENERAL] Migrating data from Oracle 9i to PostgreSQL

2006-04-04 Thread A. Kretschmer
am 04.04.2006, um 14:01:30 +0200 mailte [EMAIL PROTECTED] folgendes: > > Hi :-) > > I sure hope I'm asking in the right place... > > Is there any automated or semi-automated way of migrating data from Oracle > database (9.2.0.4) to PostgreSQL one? http://techdocs.postgresql.org/#convertfrom

[GENERAL] Migrating data from Oracle 9i to PostgreSQL

2006-04-04 Thread krokodylek
Hi :-) I sure hope I'm asking in the right place... Is there any automated or semi-automated way of migrating data from Oracle database (9.2.0.4) to PostgreSQL one? I only need the data, nothing else (not stored procedures, indexes, etc.), the relations are pretty simple, for example: CREATE T