Datalink views? 1

[jballum]

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

 

[Guest_imported]

JB, I believe that you are actually talking about local views on remote database tables.
There is a method called surrogate user technique which works like you explained.
I suggest the following article in Oracle magazine:

http://www.oracle.com/oramag/webcolumns/makkar.html

luci@cs.utt.ro

 

[jballum]

Thanks for the response sleepy.

That link has expired but thanks anyway.

I still don't see any advantages to creating a view locally based only on remote tables from the same database. Rather then just declare the view on the actual server with the tables and then accessing the view remotely.

Does anybody know any advantages?

JB

 

[s1eepy]

Sorry about that dead link.
Try this one:

http://www.ausoug.org/vic/ausoug/select/2000/october/articl09.htm

it's almost the same (it really works )

luci@cs.utt.ro

 

[Nebuchednezzar]

One advantage I've found in defining views for remote tables is security...

I don't want certain users connecting to my remote database, so I set up a local view which uses a link to select from those table(s)...then give select rights to that view.

Also handy when we need to write reports with 3rd party tools and join local tables with remote data (set up a local view...allows the reporting software which can only do one database login to see the data as if it were local and can therefore do joins, etc....)