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

This article mainly shows you "how to modify the location of data files in the database". The content is easy to understand and clear. I hope it can help you solve your doubts. Let the editor lead you to study and learn the article "how to modify the location of data files in the database".

[1] View the location of the data file

SQL > select file_name,TABLESPACE_NAME from dba_data_files

FILE_NAME TABLESPACE_NAME

/ oracle/BIQ/sapdata1/system_1/system.data1 SYSTEM

/ oracle/BIQ/sapdata1/sysaux_1/sysaux.data1 SYSAUX

/ oracle/BIQ/sapdata1/undo_1/undo.data1 PSAPUNDO

/ oracle/BIQ/sapdata2/sr3_1/sr3.data1 PSAPSR3

[method 1] in the state of mount, you first need to shut down the database.

a. Copy data files at the operating system level

Cp / oracle/BIQ/sapdata1/sr3730_3/sr3730.data3 / oracle/BIQ/sapdata1/sr3730_3/sr3730.data3

b. Start the database to the mount state and modify the location of the data file in the control file through the alter command

SQL > alter database rename file'/ oracle/BIQ/sapdata1/sr3730_3/sr3730.dataa3' to'/ oracle/BIQ/sapdata1/sr3730_3/sr3730.data3'

c. Start the database

SQL > alter database open

[method 2] operate by means of OFFLINE

a. Perform offline operations on tablespaces

Alter tablespace PSAPSR3 offline normal

b. Rename the data file

SQL > alter database rename file'/ oracle/BIQ/sapdata1/sr3730_3/sr3730.dataa3' to'/ oracle/BIQ/sapdata1/sr3730_3/sr3730.data3'

c. Perform online operations on tablespaces

Alter tablespace PSAPSR3 online

The above is all the contents of the article "how to modify the location of data files in the database". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.