Hi, I want to update one column in big table, I use two method, but both do not work,
MERGE INTO RS_DAYTIME_DATA DST
USING (SELECT LONGITUDE,
LATITUDE,
DATE_,
OLR_D
FROM NOAA_OLR) SRC
ON (DST.LONGITUDE = SRC.LONGITUDE AND DST.LATITUDE = SRC.LATITUDE AND DST.DATE_ = SRC.DATE_)
WHEN MATCHED THEN
UPDATE SET DST.OLR_NOAA = SRC.OLR_D;
for this, it has errors,
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
for the two method:
UPDATE RS_DAYTIME_DATA DST
SET DST.OLR_NOAA =
(SELECT SRC.OLR_D
FROM NOAA_OLR SRC
WHERE DST.LONGITUDE = SRC.LONGITUDE
AND DST.LATITUDE = SRC.LATITUDE
AND DST.DATE_ = SRC.DATE_);
it cost one whole night, and still no result;
the two table is very big, do you have a good solution?