A new client is complaining about performance issues.
I asked about their environment and they said they have a view server (I assume a database server but the database only has views set up on it) (Oracle 8.1.7) which consists solely of datalink views made up of base tables found in a database on a different database server (Oracle 8.0.6).
Does anyone know what the heck a datalink view is?
Does anyone know why anyone would have a set up this way rather than having the views on the database server and that is that?
If anyone can point me in a direction it would be greatly appreciated.
Thanx
JB
I asked about their environment and they said they have a view server (I assume a database server but the database only has views set up on it) (Oracle 8.1.7) which consists solely of datalink views made up of base tables found in a database on a different database server (Oracle 8.0.6).
Does anyone know what the heck a datalink view is?
Does anyone know why anyone would have a set up this way rather than having the views on the database server and that is that?
If anyone can point me in a direction it would be greatly appreciated.
Thanx
JB