Postgres Pro
Downloads
Home   >   mailing lists

Does ora2pg work with Oracle9i? - Mailing list pgsql-general

From chanc@thailand.net (chanc)
Subject Does ora2pg work with Oracle9i?
Date
Msg-id d0551d45.0403190258.69b3e494@posting.google.com
Whole thread Raw
List pgsql-general
Tree view 
I got this kind of error message when trying to copy out from
Oracle9i.
[Red Hat 8.0, Oracle9i Release 2, DBI-1.42, DBD-Oracle-1.15,
DBD-Pg-1.32, ora2pg-2.1]

DBD::Oracle::db prepare failed: ORA-00942: table or view does not
exist (DBD ERROR: error possibly near <*> indicator at char 46 in
'SELECT COUNTRY_ID,COUNTRY_NAME,REGION_ID FROM <*>COUNTRIES') [for
Statement "SELECT COUNTRY_ID,COUNTRY_NAME,REGION_ID FROM COUNTRIES"]
at Ora2Pg.pm line 1321.
Can't call method "errstr" on an undefined value at Ora2Pg.pm line
1321.

Does anyone successfully use ora2pg to copy data from Oracle9i?

Regards,
Chanc

pgsql-general by date:

Previous
From: "Patrick Hatcher"
Date:
Subject: Where are these tables??
Next
From: "Grace C. Unson"
Date:
Subject: Transaction Isolation Level returned