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
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?
![[ENGSUB] UNPRODUCTIVE DAY ใช้ชีวิต (เปื่อยๆ) ด้วยกัน 1 วัน! | OUROAD CLOSEFRiEND SS2 EP.9](http://i.ytimg.com/vi/pyYKZ3kra9w/mqdefault.jpg)
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
github.com/connormcd/listagg_clob might help
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?
Since you are on 23, you might be able to use shrink tablespace. connor-mcdonald.com/2023/11/09/express-edition-needs-bigfile/