Hi all,
I have an ORACLE 10g Database (A) and I have a materilized view in 10g based on another database in 9i (B) the problem is that querying this view is taking around 7 hrs.
On the other hand, if I create the same view in another Database (C) Oracle 9i. The time is taking around half an hour.
Is there anything I can do to solve this problem in Oracle 10g??