Thanks for the tip on enclosing the column/table name in double quotes, but in my case, I'm still running into some problems accessing the SQL Server tables from Oracle. I get the following errors:
SQL> select "SystemAcronym" from "7E7_Arch.dbo.vw_7e7_apps"@ARCH7E7RO; select "SystemAcronym" from "7E7_Arch.dbo.vw_7e7_apps"@ARCH7E7RO * ERROR at line 1: ORA-28536: error in processing Heterogeneous Services initialization parameters ORA-28507: error in data dictionary view sys.hs$_class_init ORA-02063: preceding 2 lines from ARCH7E7RO ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist
The suggestion does not work because the table or view that does not exist is not in the remote database. Rather, it is a data dictionary view that is having problmems. This is an example of why all error messages are important, not just one.
I would suggest running the $ORACLE_HOME/rdbms/admin/caths.sql script again as SYS to recreate the Heterogeneous Services views.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.