DEAR, all. I have problem with creating proxy table in SA12. There is view on oracle 11g and I want to use this view for creating proxy table SA12. But it is not possible to create.. is it impossible to create proxy table using view?
CREATE EXISTING TABLE "DBA"."V_UNIST_HR_INFORM" AT 'UNIST_ORACLE:UNIST:V_UNIST_HR_INFORM';
I just want to select(read) the view on oracle 11g... is there any other way to do that for it?
Thanks and Best regards, hakwoo KIM
asked 28 Oct '13, 22:08
The CREATE EXISTING TABLE statement needs a remote server, which can be created using
CREATE SERVER and an external login CREATE EXTERNLOGIN.
I have not used proxy tables with Oracle, however, it seems your proxy location string is unusual: You are using ":" as a delimiter whereas the usual (or required?) delimiter is a dot, and I would assume an Oracle table definition would require four parts: server name, database name, schema name and table/view name - so it would require 3 dots.
Cf. this sample location string from the docs:
To clarify the "proxy view" issue: Are you able to create a proxy table to an Oracle table, or does that fail as well?
answered 30 Oct '13, 05:40