-
About remote database
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.
_____________________________
Loren
-
if I remember right oracle 7 and 9i cannot go together
-
I'm having the same problem with 8.1.7 and 9i. Is this the same case as well??
Cheers
Kev
-
nope - 8i to 9i is possible, in fact many people use it to get 9i to 7
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|