How to import data from Oracle view
Hi,
i want to import data from Oracle view. I see only tables in the list, no views.
Is it possible at all to import data from a view ? If so, how to do it ?
Thanks,
Michel
i want to import data from Oracle view. I see only tables in the list, no views.
Is it possible at all to import data from a view ? If so, how to do it ?
Thanks,
Michel
Find more posts tagged with
Sort by:
1 - 2 of
21
Hi Balazs,
I have overlooked the input field for sql script - thanks for the hint ! I'm using the operator Read Database.
Warm regrads,
Michel
I have overlooked the input field for sql script - thanks for the hint ! I'm using the operator Read Database.
Warm regrads,
Michel
Sort by:
1 - 1 of
11
Hi Balazs,
I have overlooked the input field for sql script - thanks for the hint ! I'm using the operator Read Database.
Warm regrads,
Michel
I have overlooked the input field for sql script - thanks for the hint ! I'm using the operator Read Database.
Warm regrads,
Michel
It seems that the detection of views is not correct for Oracle, at least not in your Studio. It works correctly for me in other database types (no Oracle to test).
However, you can always specify the view name and read from it if you have the access permissions.
Which operator are you trying to use? Read Database? The In-Database extension?
Regards,
Balázs