Home » Applications » Oracle Fusion Apps & E-Business Suite » How to create a view in a remote database
How to create a view in a remote database [message #123979] Wed, 15 June 2005 15:31 Go to next message
rsury
Messages: 26
Registered: May 2005
Junior Member
Suppose we have two db. One Oracle Apps DB and other is Custom DB

The database link is there from Oracle Apps DB to Custom DB

Is it possible to create a view in Custom DB from Oracle Apps using Oracle PO_Vendor and site tables.

Tx
Re: How to create a view in a remote database [message #124788 is a reply to message #123979] Tue, 21 June 2005 09:05 Go to previous message
DBAHardy
Messages: 3
Registered: June 2005
Junior Member
1. Create a DB link in Custom DB pointing to the Apps DB, Connecting to PO user.
2. Using this DB link, create view on Oracle PO_Vendor and site tables,
create or replace view as select...... from PO_Vendor@ORACLE_APPS_DB_LINK where ....
Previous Topic: Database Connectivity
Next Topic: database server for e-business suite
Goto Forum:
  


Current Time: Thu Mar 28 20:14:48 CDT 2024