While updating/copying the data from old column to new column we are facing the issue with tablespaces in database.

Records count: 158 million+

Using below query to update the records,

UPDATE TABLE_NAME SET NEW_COLUMN = OLD_COLUMN: 

I updated the tablespace for the 3 times, but issue is not resolve.