Select CLOB data via database link
Hi all,
I have a SQL statement to query data from remote table by using database link. This table have a CLOB datatype, so my query select <clob_value_field> from <remote_table>@<db_link> has failed.
I have checked some links, I can create table with CAS (create ... as select ...) in local database then query data from it. But if this table have a huge data, so creating table with CAS will take more time. Do we have other solutions for querying clob data from remote table ?
My oracle version is 12c.
Thanks,