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

Editor to share with you oracle11g how to modify the data file path, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

Sometimes if we want to move the data file to another directory, we can do the following:

View data file location

SQL > select file_name from sys.dba_data_files FILE_NAME----/home/app/oracle/oradata/orahq/users01.dbf/home/app/oracle/oradata/orahq/undotbs01.dbf/home/app/oracle/oradata/ Orahq/sysaux01.dbf/home/app/oracle/oradata/orahq/system01.dbf

two。 Shut down and boot to mount state

SQL > shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL > startup mount;ORACLE instance started.Total System Global Area 2.1379E+10 bytesFixed Size 2262656 bytesVariable Size 1677724032 bytesDatabase Buffers 1.9663E+10 bytesRedo Buffers 36073472 bytesDatabase mounted.3. Modify SQL > alter database rename file'/ home/app/oracle/oradata/orahq/users01.dbf' to'/ alidata1/oradata/orahq/users01.dbf';Database altered.SQL > alter database rename file'/ home/app/oracle/oradata/orahq/undotbs01.dbf' to'/ alidata1/oradata/orahq/undotbs01.dbf';Database altered.SQL > alter database rename file'/ home/app/oracle/oradata/orahq/sysaux01.dbf' to'/ alidata1/oradata/orahq/sysaux01.dbf' Database altered.SQL > alter database rename file'/ home/app/oracle/oradata/orahq/system01.dbf' to'/ alidata1/oradata/orahq/system01.dbf';Database altered.

4. Start the database

SQL > alter database open;Database altered. The above is all the contents of the article "how to modify the data file path in oracle11g". 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.