Remove Deploy Target from JDeveloper
When you use JDeveloper and deploy a project from JDeveloper to a server, JDeveloper remembers this, so you can easily deploy to it again. You can do this by …
after 27+ years in Oracle land I am forced to patch sqlplus
When starting to use sqlplus 12.2 I noticed that my SQL prompt was not changing to what login.sql told it to be. This did not happen in sqlplus 12.1 …
ETL using Oracle DBMS_HS_PASSTHROUGH and SQL Server
June 12, 2017
Oracle, Databases, DBA Oracle, ODA, Oracle 12, Performance and tuning, PL/SQL
No Comments
While I prefer a “loosely coupled architecture” for replication between Oracle and SQL Server, sometimes a direct (database) link cannot be avoided. By using DBMS_HS_PASSTHROUGH for data extraction the …