Thread: Does ora2pg work with Oracle9i?

Does ora2pg work with Oracle9i?

From
chanc@thailand.net (chanc)
Date:
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

Re: Does ora2pg work with Oracle9i?

From
chanc@thailand.net (chanc)
Date:
Sorry, it's because I didn't specify SCHEMA=something.
It's works.

Regards,
Chanc