0

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.

Improve this question
10
  • Which problems and how do they sow up error message ? Commented Apr 23, 2024 at 12:29
  • every time we need to increase the tablespace if the execution failed. Commented Apr 23, 2024 at 14:39
  • Can you please suggest the right way to do the copy one column data into another. Commented Apr 23, 2024 at 14:41
  • what means lage amount of data, varvhar(4000)? Commented Apr 23, 2024 at 15:01
  • 1
    Recreate the table: CTAS to new table with fixed data, then drop old table and rename new table to old. Add any needed constraints and grants. Segment recreation is vastly faster than doing a mass update of every row. Commented Apr 25, 2024 at 1:47

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.