Image by Mudassar Iqbal from Pixabay Sometimes you need to be practical and apply some tricks to get the job done instead of waiting for the perfect tool. With SQL Developer Command Line you can load CSV with millions of lines with not too much hassle. Loading large CSV files to Oracle database After a long summer break it is time to start blogging again. Today I loaded a CSV file containing all companies in Norway registered at The Brønnøysund Register Centre . It has over 1.1 million lines, more than you want to open in a GUI like SQL Developer. But SQL Developer has a command line version that is almost perfect for the job. You’ll find the download link and more information at https://www.oracle.com/database/sqldeveloper/ . This URL always gives you the latest version and from a Mac or Linux box you can just do: ...

Images by OpenClipart-Vectors from Pixabay Got too much data in the database? Offloading it to object storage is one option. Even better, get stuff in to the database and analyse it with SQL. Accessing OCI Object Storage from PL/SQL As mentioned in a previous post about OCI Object Storage I wanted to investigate how to access the OCI Object Storage from PL/SQL, in an Autonomous Database1. ...

Oracle launched version 23ai of the database May 2. Immediately after the event we could pull the Free edition from the Oracle Container Registry and play with it. I blogged about how you can set up 23c Free in Your Own Oracle Database Lab in 1-2-3 218 days ago 1. This command pulls the latest version: podman pull container-registry.oracle.com/database/free:latest Have a look in Your Own Oracle Database Lab in 1-2-3 for more details on how to create a new container with it. I created mine with: ...

Update: See this post for an update for version 2.1 on Oracle Linux. How to install OML4Py Client on Ubuntu 22.04 I needed the Oracle Machine Learning for Python (OML4Py) Client (not the Server) in order to convert a pretrained model so that I could import it into the newly released Oracle database 23ai. I wrote this from information I found in the User’s Guide and a lot of internet search. The PC I am using for this runs Ubuntu, so I adapted the installation for Ubuntu 22.04 (Jammy Jellyfish). After I completed the whole procedure I decided to verify it on a fresh Vagrant box: ...

Stuffing files away in the cloud might not be on your bucket list, but object storage in Oracle Cloud is quite useful in several situations. Storing files in OCI Object Storage Object storage can be used as you would use Amazon’s S3 through a special API provided in OCI. You can even store your RMAN database backups through a Swift API. But I will just upload and download a bunch of files. ...

ORA-01835 day of week conflicts with Julian date - This means your weekday in input is wrong. ORA-01835 This error message is also a bit confusing, especially if you were not using a Julian date at all; the error messages probably reflects how Oracle calculates dates. You are likely to encounter this error when you are do testing or some how construct a string to be parsed by to_date or to_timestamp. It just means that you specified an incorrect weekday for a date. Like today, April 17, 2024 is a Wednesday. ...

The error message ORA-01950 should be easy to solve, but perhaps you forgot the indexes? ORA-01950 ORA-01950 no privileges on tablespace … usually has a couple obvious solutions. If the tablespace in the error message is wrong like SYSTEM, the default tablespace must be changed for the user. Change it with something like this: alter user luser default tablespace users quota 1g on users; If the tablespace is correct, the user may be lacking a quota on the tablespace. The fix is almost the same: ...

Large Language Models (LLM) are everywhere now, now you can even get help with your SQL. A few months back, Oracle introduced a feature in the Autonomous Database where you can ask normal questions in order to query your data. First Journey with SelectAI Brendan Tierney at Oralytics has written two good articles, SelectAI – the beginning of a journey and SelectAI – Doing something useful on a cool feature in the Oracle Autonomous database; SelectAI. He shows how you in a few steps can query your data using natural language. I followed the steps in his posts, and in a few minutes got it to work in my own Autonomous Database that I am using in the Oracle Free Tier. ...

Your Own Oracle Database Lab in 1-2-3 #JoelKallmanDay You can’t release to production all the time. Sometimes you need to learn, try out stuff, and even have some fun. This post is about how you can get an Oracle database up and running in minutes (even in seconds) when you just need to do some experiments. The fastest way to achieve that is using a prebuilt container from Oracle. This works nicely on Linux, Windows, and MacOS. ...

Oracle REST Data Services (ORDS) offers a seamless installation experience in the root container. By making a simple configuration adjustment, all pluggable databases can effortlessly be addressed, empowering users with enhanced functionality and convenience. Installing ORDS in the root container At one of my customers, Oracle Application Express (APEX) has been successfully deployed with Oracle REST Data Services (ORDS) running on Tomcat. However, ORDS was primarily utilized as a proxy for APEX in the database, with limited exploration of its broader capabilities. Typically, ORDS was installed within the pluggable database (PDB) as a natural choice. ...