Hi all,
I created a db link and query a remote table. It's successful whenever I used @dbname.world but I got error ORA-02019 whenever I ommited .world from the query.
Below are the details:
create database link dbname connect to userA identified by userA using 'dbname.world';
I even try these combinations:
create... dbname.world ....using 'dbname.world'
create... dbname.world ....using 'dbname'
create... dbname ....using 'dbname'
All did not seem to work without .world
select count(*) from userA.tableA@dbname.world; -- OK
select count(*) from userA.tableA@dbname; -- return error ORA-02019.
What could be wrong ??? Please help...
Rgds,
Suhaimi
I created a db link and query a remote table. It's successful whenever I used @dbname.world but I got error ORA-02019 whenever I ommited .world from the query.
Below are the details:
create database link dbname connect to userA identified by userA using 'dbname.world';
I even try these combinations:
create... dbname.world ....using 'dbname.world'
create... dbname.world ....using 'dbname'
create... dbname ....using 'dbname'
All did not seem to work without .world
select count(*) from userA.tableA@dbname.world; -- OK
select count(*) from userA.tableA@dbname; -- return error ORA-02019.
What could be wrong ??? Please help...
Rgds,
Suhaimi