Database Administration (MOSC)

MOSC Banner

Querying via database links

edited Dec 12, 2013 10:25AM in Database Administration (MOSC) 17 commentsAnswered
I have a database link created between DB1 and DB2, called DB1_To_DB@ and I am trying to query a view on DB2 called Main_view. I am logged in to DB1 and run the following query:

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center