How To Move Lob Data in a Table To Another Tablespace


In some cases, we may need to move the lob columns in a table to another tablespace.

You can do this with the following command online:

After Move, the data in the lob column of the table will be moved to the new tablespace. Other data of the table will be kept in the tablespace of the table. We’re just gonna move the lob data.

Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *