Hi,
I try to migrate an Oracle database 9.2.0.5 ( one schema)
to an Postgresql (8.1.3) database.
I use ora2pg to do this ...
When I use it after a while I get the following error:
MONTANTTVARECUP => type:NUMBER , length:22, precision:, scale:,
nullable:Y , default:
DTCREA => typ
Thanks for the answer...
the configuration is as below:
Oracle > Ora2pg> PostgreSQL
Windows 2000Linux Windows 2000
500 MB 3 GB256 MB
Ora2pg.pl is executed on linux
top gives for porcess ora2pg.pl
VIRTRES
44272 28m
T
Thanks fro your answer ...
TRANSACTIONS has 55412 rows
to much ??
"E. Lefty Kreouzis" <[EMAIL PROTECTED]>
22/02/2006 12:38
Pour : [EMAIL PROTECTED]
cc :pgsql-general@postgresql.org
Objet : Re: [GENERAL] Out of memory using ora2pg
> Hi,
>
>
> I try to migrat
I tried with less tables
and it works now
thanks again for your help
Tom Lane <[EMAIL PROTECTED]>
22/02/2006 15:58
Pour : [EMAIL PROTECTED]
cc :pgsql-general@postgresql.org
Objet : Re: [GENERAL] Out of memory using ora2pg
[EMAIL PROTECTED] writes:
> Du
Hi,
I try to load an entire database ( from Oracle via ora2pg )
create table is OK
there are some FK's in the database
I did insert's with :
BEGIN TRANSACTION;
SET CONSTRAINTS ALL DEFERRED;
insert ...
END TRANSACTION;
I get:
ERROR: insert or update on table "transactions" violates foreign key
Hi,
I try to insert 55000 rows into a table
The firsts insert seems ok (few rows are OK )
then after a while I et the following erorrs
psql:c:/temp/usrweb/transactions.sql:55420: ERROR: current transaction is
abort
ed, commands ignored until end of transaction block
What may be the problem ?
hi,
I try to dump a database 8.1.3 on windows
from pg_dump from 8.0 on Linux
no result
is it a normal behavior ?
Thanks ...
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail co
