Category: Oracle DB

  • DBCP: database connection pooling (service) — this one lists (most of) the following links:;a=tree;f=doc;hb=refs/heads/master — examples Tomcat:

  • Oracle DB as VirtualBox appliance (2017-06-14 update) If you already are VirtualBox-minded, this is a very nice approach to get Oracle DB running.

  • “Oracle Instant Client” for Linux x86-64 (RPM) – why not “*.so.X.2”?

    Why is this: (why not “.so.10.2“?): ./usr/lib/oracle/ ./usr/lib/oracle/ ./usr/lib/oracle/ -> ./usr/lib/oracle/ -> ./usr/lib/oracle/ (why not “.so.11.2“?): ./usr/lib/oracle/11.2/client64/lib/ ./usr/lib/oracle/11.2/client64/lib/ ./usr/lib/oracle/11.2/client64/lib/ -> ./usr/lib/oracle/11.2/client64/lib/ -> ./usr/lib/oracle/11.2/client64/lib/ (why not “.so.11.2“?): ./usr/lib/oracle/11.2/client64/lib/ ./usr/lib/oracle/11.2/client64/lib/ ./usr/lib/oracle/11.2/client64/lib/ -> ./usr/lib/oracle/11.2/client64/lib/ -> ./usr/lib/oracle/11.2/client64/lib/ (why not “.so.12.2“?): ./usr/lib/oracle/12.2/client64/lib/ ./usr/lib/oracle/12.2/client64/lib/ ./usr/lib/oracle/12.2/client64/lib/ ./usr/lib/oracle/12.2/client64/lib/ -> ./usr/lib/oracle/12.2/client64/lib/ -> […]

  • Perl’s DBD::Oracle vs Debian For accessing an Oracle DB server from a client computer (w/o its own Oracle DB server installation) you need “Oracle Instant Client” (a set of packages of installables for various computer architectures, supplied by Oracle for free): You won’t find Oracle Instant Client for Debian (outside your organisation or company), but …: […]

  • “Oracle Instant Client” vs Debian (resp. Ubuntu) Of course “Oracle Instant Client” is closed source, does not comply with Debian rules, and cannot / may not be distributed through Debian channels. Oracle supplies RPM files for “Linux x86-64” but no “.deb” files. And presumably both Oracle and also the “Debian Project” disallow redistribution of “Oracle Instant Client” components as Debian […]

  • Oracle Instant Client: “free, light-weight, and easily installed Oracle Database tools, libraries and SDKs for building and connecting applications to an Oracle Database instance”

  • how to create a Debian package from an RPM package? “rpm2deb”

    I moved the content to a wiki article, so this article is a little obsolete. : alien -k … Open questions: how to deal with dependencies specified within the RPM package? …

  • Oracle SQL scripts: how to use a variable for the table name There is a “test table” and there is a “serious table” – use a variable name for the table(s) in question!

  • how can I create a copy of an Oracle table without copying the data? create table xyz_new as select * from xyz where rownum < 0; In Oracle SQL Developer use the menu-function (maybe right-click) on the table you want to operate on (i.e. that you want to copy), “Table“, “Copy…“, w/o checking “Include Data“.

  • Oracle SQL Developer – how to run it on Windows in English w/o admin rights? I chose the approach “set language at runtime“: sqldeveloper.exe –AddVMOption=-Duser.language=en Works like a charm. On the Win7 PC at work I have no admin rights, therefore I cannot change the config file mentioned in the thread.