Querying via database links
SELECT FIELD1 "Field 1", FIELD2 "Field 2"
FROM Main_view@DB1_TO_DB2
WHERE START_TIME > SYSDATE-1
AND FIELD3='Open'
ORDER BY FIELD1;
I get an error
ERROR at line 2:
ORA-00942: table or view does not exist
ORA-02063: preceding line from DB1_TO_DB2