I never installed Oracle on my system and don’t know why these directories kept being created, but I finally managed to stop them from reappearing. Here’s how it’s done. First, head over to: cd ~/oradiag_<username>/diag/clients/user_<username>/host_*/trace/ and then head sqlnet.log You should see an error message complaining about a directory not existing for r/w. For me, … Read more
Section 3 of RFC4122 provides the formal definition of UUID string representations. It’s 36 characters (32 hex digits + 4 dashes). Sounds like you need to figure out where the invalid 60-char IDs are coming from and decide 1) if you want to accept them, and 2) what the max length of those IDs might … Read more
Performance depends on the Oracle version you use. Locks are generated anyway. If version <= Oracle 11.1 then #1 does the same as #2. It is slow anyway. Beginning with Oracle 11.2, Oracle introduced a great optimization for the first statement (one command doing it all). You don’t need to change the command – Oracle … Read more
In earlier times you were always forced to use DBMS_LOB package. Then in Oracle 10g a feature called “SQL semantics for LOB” was introduced and now you can use the simplified syntax. In CREATETEMPORARY you can specify the duration of the LOB in SQL semantic you cannot. In your case the LOB is freed in … Read more
This seems to be Oracle’s official repository for docker – https://github.com/oracle/docker-images More details here – https://blogs.oracle.com/oraclemagazine/deliver-oracle-database-18c-express-edition-in-containers
From official doc – 4.3.1 The default isolation level for that method is SERIALIZABLE, which is quite aggressive: READ_COMMITTED would work just as well; READ_UNCOMMITTED would be fine if two processes are not likely to collide in this way. However, since a call to the create* method is quite short, it is unlikely that the … Read more
Yes, it’s possible. E.g. on Linux, run ssh -N -Llocalport:dbserver:dbport yourname@connectionserver where localport is the port on your machine which will be forwarded (can be 1521 if there is no local instance of oracle running) dbserver is the name or IP of the database server dbport is the port of the database (usually 1521) yourname … Read more
declare x number; begin x := myfunc(myargs); end; Alternatively: select myfunc(myargs) from dual;
Since Oracle 9i there are two ways or declaring a directory for use with UTL_FILE. The older way is to set the INIT.ORA parameter UTL_FILE_DIR. We have to restart the database for a change to take affect. The value can like any other PATH variable; it accepts wildcards. Using this approach means passing the directory … Read more
The instantclient works only by defining the folder in the windows PATH environment variable. But you can “install” manually to create some keys in the Windows registry. How? 1) Download instantclient (http://www.oracle.com/technetwork/topics/winsoft-085727.html) 2) Unzip the ZIP file (eg c:\oracle\instantclient). 3) Include the above path in the PATH. 4) Create the registry key: Windows 32bit: [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE] … Read more