Is it possible to create oracle linked server in other oracle server? I actually wanted to do this with sql server but in sql server I couldn't run long query (8000 limit).
I have access to remote database but only read only
I can't create views and stored procedure.
I want to create linked server and with it's help create views in my local oracle database. Is this feasible and is the speed of query execution comparable?