I am updating a CLOB column from a varchar2 column in the same table. My sql is:
update mytable a
SET ON_NARRATIVE_CLOB=(select RTRIM(EXTRACT(XMLAGG(XMLELEMENT("x", NARRATIVE||chr(32)) order by LINE), '/x/text()').getclobval(),',')
from mytable b
where a.column= b.column
I have 1.2 million rows. The update is very slow. Any suggestions, comments, direction would be appreciated. This is a one-time load for now and incrementals after this first load but I would like to get it as fast as possible. Oracle 11.2. Should I rewrite with PL/SQL? Use a staging table? Thanks.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.