Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to change the tablespace in the database, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, let the editor take you to understand it.

SQL > alter tablespace CSFIS offline

The tablespace has changed.

Alter tablespace CSFIS rename datafile'D:\ ORADATA\ SFIST\ ORADATAFILE\ CSFIST01.ORA' to'F:\ oracleDATE\ CSFIST01.ORA'

1. Alter tablespace tablespace name offline

two。 Copy all the data files of users and the related dbf files in the oradata directory to a new place.

3. Then alter tablespace tablespace name rename datafile 'original data file name (with full path)' to 'new data file name (with full path)

4. Alter tablespace tablespace name online

5. The old data file can be deleted.

Thank you for reading this article carefully. I hope the article "how to change tablespaces in the database" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.