Skip to Content
0
Sep 18, 2014 at 06:43 AM

ORA-00904 importing Oracle 8i tables from BODI XI 3.0

70 Views

We are using Data Integrator XI 3.0. Our local repository is a Oracle 10g database.

When trying to import tables from Oracle 8i data source to the local repo Oracle 10g datastore, we encounter this error.

BODI-1112338: Error: Cannot import metadata.

Oracle <XXX> error message for operation <OCIStmtExecute> : <ORA-00904: Invalid column name>

Understand it is out of support, however, this Oracle 8i DB is owned by other App Team and we were told DB upgrade is not an option.

Is there a way to import tables from Oracle 8i data source? We need the data from this Oracle 8i DB for our ETL jobs.