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