7 Replies Latest reply on May 26, 2015 12:26 PM by 2899665

    using sqldeveloper connection as a poor man's dblink

    2899665

      i seem to recall reading (on Jeff Smith's blog perhaps ?) that sqldeveloper supported a special syntax to allow using connections almost like dblinks. So something along the lines of the query below (except it is obviously not excactly that or i would not be asking). The "cnx_name" below represents a sqldev connnection name, thus behaving somewhat like an on-the-fly dblink.

      create table MYTABLE as select * from SRCTBL@"cnx_name";

      (to be run as an <F5> script)

       

      The "copy db" feature is working but a bit overkill when copying a single table like here.