Remote views?

From: Joe Grgas <joeyd_at_hunterlink.net.au>
Date: Thu, 21 Jan 1999 20:21:39 +1100
Message-ID: <36A6F1A2.2F7BB8FB@hunterlink.net.au>

Hi I'm a relative newbie to Oracle and pl/sql ( 6 months ) and I'm not sure about something...

I'm working with a newly designed oracle database and I have to grab data from other databases ( some of them oracle, some not ) and populate my tables. These other databases are being updated all the time so I need to do this on the fly as needed. ( I'll create a stored procedure to do this )

Somebody told me the way to do this is to create a 'remote view' to the other database ( say for arguments sake another oracle database ). Once this view is created I can apply the normal commands and the database I'm connected to will treat the remote view as just another view. From here I can extract my data.

How do I go about doing this?
If the database is remote how do I apply parameters for host/login/passwd

Thanks

Joe Grgas Received on Thu Jan 21 1999 - 03:21:39 CST