My response to being able to view 9i data using 9i client would be yes, since the versions would be the same. Is this the correct response?
The fact that Oracle 8.1.7 client can only access the production database is because production has an Oracle8 server. It cannot see development and test db because the databases are run on Oracle9i. This is an upward compatibility issue and nothing to do with running the same version. If the client was Oracle9i, then it would access Oracle8 server as well as Oracle9i.
Dig Deeper on Using Oracle PL-SQL
Related Q&A from Azim Fahmi
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.