Avoiding space problems with Oracle Database Free

The various versions of the free Oracle Database come with storage limits, and if you hit those limits, you might be stuck with a lot of work to resolve the issue. Take these steps early to avoid pain later.
Blog post covering the steps connor-mcdonal...
Follow me!
blog: connor-mcdonal...
twitter: / connor_mc_d
The Podcast!
podcasts.apple...
open.spotify.c...
Subscribe for new tech videos every week
Other social media channels here: linktr.ee/connor
Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla
#sql #database

[@prakash5935]

Hello, I'm encountering the ORA-01489 error indicating that the result of string concatenation is too long. I've tried several approaches, including using XMLAGG, but the issue persists. Could you please advise on how to resolve this?" That text data contains date, string, number values

[@DatabaseDude]

github.com/connormcd/listagg_clob might help

[@liviusandu4379]

As we know, the free 23c database supports 12 GB. For the first time it happened on a database to reach 12 gb. I hoped that I could see the database, but I can no longer insert data. Error, no longer loading freepdb1 at all. Are there recovery solutions, except for an upgrade?

[@DatabaseDude]

Since you are on 23, you might be able to use shrink tablespace. connor-mcdonald.com/2023/11/09/express-edition-needs-bigfile/