Amar,

I think I'll create a dblink then view as you mentioned. But I need to make sure that I've got all the details correct.

My scenario is I need to have read only access from DB A to DB B.

1) Database link

CREATE PUBLIC DATABASE LINK A (Do I need to edit tnsnames.ora to add this entry in the source area or target area?)


2) Create view AB as select * from [email protected]d with read only;

Can you let me know if this is correct?


Thanks

J