數(shù)據(jù)庫(kù)中alter database rename file to子句怎么用

小編給大家分享一下數(shù)據(jù)庫(kù)中alter database rename file  to子句怎么用，希望大家閱讀完這篇文章之后都有所收獲，下面讓我們一起去探討吧！

database_file_clauses 

    The database_file_clauses let you modify data files and temp files. You can use any of the following clauses when your instance has the database mounted, open or closed,  and the files involved are not in use.

RENAME FILE Clause 

     Use the RENAME FILE clause to rename data files, temp files, or redo log file members. You must create each filename using the conventions for filenames on your operating system before specifying this clause.
使用RENAME FILE子句重命名數(shù)據(jù)文件，臨時(shí)文件或重做日志文件成員。 在指定此子句之前，必須使用操作系統(tǒng)上的文件名約定創(chuàng)建每個(gè)文件名。

• To use this clause for a data file or temp file, the database must be mounted. The database can also be open, but the data file or temp file being renamed must be offline. In addition, you must first rename the file on the file system to the new name.
  要將此子句用于數(shù)據(jù)文件或臨時(shí)文件，必須裝入數(shù)據(jù)庫(kù)。 數(shù)據(jù)庫(kù)也可以打開，但重命名的數(shù)據(jù)文件或臨時(shí)文件必須處于脫機(jī)狀態(tài)。 另外，您必須首先將文件系統(tǒng)上的文件重命名為新名稱。
  
  

• To use this clause for logfiles, the database must be mounted but not open.
  要將這個(gè)子句用于日志文件，數(shù)據(jù)庫(kù)必須安裝但不能打開
  
  

• If you have enabled block change tracking, then you can use this clause to rename the block change tracking file. The database must be mounted but not open when you rename the block change tracking file.
  如果啟用了塊更改跟蹤，則可以使用此子句來(lái)重命名塊更改跟蹤文件。 重命名塊更改跟蹤文件時(shí)，數(shù)據(jù)庫(kù)必須安裝但不能打開
  
  

This clause renames only files in the control file. It does not actually rename them on your operating system. The operating system files continue to exist, but Oracle Database no longer uses them.
    該子句僅重命名控制文件中的文件。 它實(shí)際上并沒有在你的操作系統(tǒng)上重命名它們。 操作系統(tǒng)文件繼續(xù)存在，但Oracle數(shù)據(jù)庫(kù)不再使用它們。

Oracle Database Backup and Recovery User's Guide for information on recovery of data files and temp files

• "Renaming a Log File Member: Example" and "Manipulating Temp Files: Example"

看完了這篇文章，相信你對(duì)“數(shù)據(jù)庫(kù)中alter database rename file  to子句怎么用”有了一定的了解，如果想了解更多相關(guān)知識(shí)，歡迎關(guān)注億速云行業(yè)資訊頻道，感謝各位的閱讀！