Hi All,
I need some help with understanding using Global temporary tables from physical standby database through database links.
Below is my scenario.
I have three Databases A, B and C.
A is the source Database and B is the physical standby ( using ADG) of A.
From Database A , I've created db links to Database C which reflects in Database B ( physical standby of A) as well .
When i run the below Query from A , it returns data.
From A:
Select * from temp_table@LinktoC;
----
10 rows returned
But when i run the same Query from B , it does not return any data.
From B;
Select * from temp_table@LinktoC
----
0 rows returned
I'm not clear on why is it happening. ? Please advice. Thanks!
Regards,
Bharath