codify sql

edited Apr 23, 2024 at 12:28

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:

UPDATE TABLE_NAME SET NEW_COLUMN = OLD_COLUMN:

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

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.

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.

edited tags

edited Apr 23, 2024 at 11:57

asked Apr 23, 2024 at 11:57

Copying data from old column to new column with large amount of records

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.

Return to Question