About remote database

[lorenchu]

Dear all,

I have created a new database with oracle9i. I create a database link to another oracle7.3.4 database with name '734_dblink'. And then as usual, I create a synonym to that database as follows:

create public synonym tbl_1 for tbl1@734_dblink;
create public synonym seq_1 for seq_1@734_dblink;

However, I cannot describe tbl_1 and errors occur:

desc tbl_1;
ORA-02084: database name is missing a component

Then I create another database link with name '734_dblink.world'
and describe the table, another error occurs:

desc tbl_1;
ORA-12663: Services required by client not available on the server

Though I can select, insert and update tbl_1, but i cannot write any package or function to reference this table.

For the sequence seq_1, similar errors occur and cannot be referenced in any package or function.

Is there anything I should set in oracle9i in order to let this work? Because this doesnt happen if i use oracle 734 to connect to oracle 734.

Thx in advance.

[pando]

if I remember right oracle 7 and 9i cannot go together

[kevwidd]

I'm having the same problem with 8.1.7 and 9i. Is this the same case as well??

Cheers

Kev

[davey23uk]

nope - 8i to 9i is possible, in fact many people use it to get 9i to 7