Create Oracle View using different database

Question

I have 2 databases D1 and D2 with tables T1 and T2 respectively.

CREATE VIEW V1 
AS
    SELECT
        T2Column1, T2Column2
    FROM            
        D2.T2
    WHERE        
        (T2column3 = 'condition')

This code creates a view in SQL Server. I want the corresponding Oracle code.

different database or schema ? if database then you have to use dblink — Moudiz
– Moudiz, Commented Jan 8, 2016 at 9:23
then you should create a DB linkto access the other database. if you didnt know how to do that ill post an answer after a bit — Moudiz
– Moudiz, Commented Jan 8, 2016 at 9:48
pls give me how to do that.I dont know DB link access in oracle — Safeena
– Safeena, Commented Jan 8, 2016 at 10:20

Moudiz · Accepted Answer · 2016-01-11 08:51:16Z

1

you should create a dblink ( reade more about it)

create public database link dblink test
  connect to SCHEMA_NAME
  using 'usb-o12-c1.comp.local:1000/servername'

in using go to your tnsname in your oracle folder C:\oracle\product\10\c\network\admin and take the require info 1000 represent to your port number and replace your servername

then try like this

select * from test@tab1

answered Jan 11, 2016 at 8:51

Moudiz

7,42723 gold badges87 silver badges166 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create Oracle View using different database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related