Create a View in Database 1 that queries tables in Database2?

I'm trying to Have a database with views that point to second database that will contain the tables needed for the view. Is this possible with Oracle?

create this view in Database 1 that points to database 2: Create View V1
as
Select * from Database2.Table1

or if it involves tables in the database where the view is and a second database creating the view in Database1: Create View V2
as
Select * from Table1
UNION ALL
Select * from Database2.Table2

Thank you! Received on Wed Oct 10 2001 - 16:53:20 CEST