Hi there, please I will appreciate if anyone can advice on how to do a loop insert into a table in batches of say 10,000 records.
The reason for this is that I tried to create a copy of an existing table using CTAS but I ran into trouble doing this because this table is larger with almost 9 million records including 6 CLOB columns (some of the CLOBÂ columns hold 34,000 characters) thereby getting "ORA-01652: unable to extend temp segment by 128 in tablespace"
I haven't got the privilege to extend tablespace so I created the new table as CTAS where 1=2 with the aim of inserting the records. The insert into the new table runs for ever and I had to kill it. therefore I thought it might be a good idea to do a small insert in batch of 10,000 records at a time.
I am running Oracle 12c on Windows 10. SQL Developer Version 17.3.1.279
Many thanks.