On Monday, July 20, 2020 at 8:12:17 AM UTC-7, Charles Monteiro wrote: > > this is all we do to setup the database link > > CREATE PUBLIC DATABASE LINK foreign_DB1 > CONNECT TO foreignOwner IDENTIFIED BY foreignOwner USING 'foreign_DB!'; > > CREATE PUBLIC SYNONYM foreign_table1 FOR foreign_table1@foreignOwner; > > thanks for looking into this >
I looked more into this. The oracle adapter does not use SQL to get the schema, it uses OCI8#describe_table (which comes from ruby-oci8) to get the schema. So if you want this supported in the oracle adapter, you need to get ruby-oci8 to add support for this. If you are using the jdbc/oracle adapter, Sequel uses the JDBC metadata support. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/3c49359a-dda7-4b4c-b691-1093087979d1o%40googlegroups.com.
