I am using oracle 22.214.171.124.0 and I tried to select tables from another database by using the general syntax
Select dbms_column name from schema_name.table_name@db_link;
but I somehow got this error ORA-02019: connection description for remote database not found.I typed in the right schema name and database link.
By the way the remote database is using oracle 10 g. Will this affect my sql execution??...