| Title: | SQL/Services Forum |
| Notice: | kits(3) ft info(7) QAR access (8) SPR access (10) |
| Moderator: | SQLSRV::MAVRIS |
| Created: | Thu Oct 13 1988 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 2214 |
| Total number of notes: | 8586 |
Customers are trying to use database link against Rdb...
I'm not so sure if this kind of feature is supported .
Thanks for any advise.
/Jean-Luc
---- log from SQLPLUS, under my RDBMS 7.3.3 on NT -----------
create public database link rdb
connect to jsubri identified by <pass> using 'mf_pers70_oci';
create public synonym employees for employees@rdb;
select count(*) from employees;
select count(*) from employees
*
ERROR at line 1:
ORA-02071: error initializing capabilities for remote database RDB.WORLD
ORA-00942: table or view does not exist
%SQL-F-RELNOTDEF, Table SQL_CAPABILITY is not defined in database or schema
ORA-02063: preceding 2 lines from RDB
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 2210.1 | Not Supported. | NOVA::GUZMAN | Ray Guzman -- Rdb engineering (SQL compiler/SQL*Net for Rdb) | Tue Jun 03 1997 11:09 | 10 |
No, this isn't supported at this time. I think it's mentioned in the DOC, but you might also check out the FAQ pointed to from our web page: http://nhdig1.us.oracle.com:2080/sqlnet4rdb/ We are looking at supporting this kind of think in the future. However today they still need to purchase the Transparent Gateway for Rdb. - Ray | |||||