Can I create DB link to a view

[syncdba]

Hi I have create a view
create or replace view stage_learners_v as
select cu.user_no as Internal_Learner_Identifier,
cu.employee_no as Emolpoyee_Number,
null Status,
null Manager_User_name,
cu.user_type as Employee_Type,
null Job_Type,
null Legal_Entity_Code,
jt.job_name as Title,
cu.first_name as First_Name
from boniva.CORP_USERS CU,
boniva.COUNTRY_LIST CL,
boniva.JOB_TITLE jt,
boniva.CORP_DEPT cd,
boniva.COMPANY C
where CU.COUNTRY=to_char(CL.COUNTRY_ID(+))
and CU.JOB_TITLE=JT.JOB_ID(+)
and CU.DEPT_NO=CD.DEPT_NO(+)
and CU.COMPANY_NO=C.COMPANY_ID..
I have created a VIEW in BONIVA with boniva columns.
Can I make a database link on this view & create this same view in another database say(tp2)..
Or Is there any other way I can use one DB columns & use them in other DB.
Thanks,

 

[SantaMufasa]

Sure...DBLinks work just as well for views as they do for tables.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.