While updating the data from old column to new column we are facing the issue with tablespace.
Records count: 158 million+
Using below query to update the records,
UPDATE TABLE_NAME SET NEW_COLUMN = OLD_COLUMN;
updated the tablespace for the 3 times but issue is not resolve.
New contributor
Mujahid Boramani is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.