Oracle Database In the process of use, as data increases the database files, it is gradually increased, which may cause insufficient hard disk space after reaching a certain size; then we can move the database file to another big hard disk partition. Below I will move the C disk's database file to the D disk in the Oracle for Windows, describe the method and step of the Oracle database file movement.
1. Connect to the Oracle database you want to move in SQLPLUS, then perform the following SQL statement to view the Oracle Database File Location:
SQL> SELECT FILE_NAME from Sys.dba_Data_files;
File_name ------------------------------------------------- ------------- C: /ora8/oradata/oracle/Users01.dbfc: /ora8/oradata/oracle/dr01.dbfc: /ora8/oradata/oracle/tools01.dbfc: / ora8 / OraData/oracle/indx01.dbfc:/ora8/oradata/oracle/rbs01.dbfc:/ora8/oradata/oracle/temp01.dbfc:/ora8/oradata/oracle/system01.dbf
Query 7 records.
Record the location and name of the file you want to move.
2. Let's move the file "c: /ora8/oradata/racle/Users01.dbf" to "d: /oradata/users01.dbf" as an example, to move other files, please anly the same method (according to the actual situation Modify file path and name) Operation.
<1> First let all users stop connecting to the database and turn off the database. Enter: in the command line window:
C: / SVRMGRL (Enter) SVRMGR> Connect Internal (Enter) SVRMGR> Shutdown Immediate (Enter) # Waiting for Database Tips Close SVRMGR> EXIT
<2> File "UserS01.DBF" from the "C: / ORA8 / ORADATA / ORACLE /" directory, then copy it to the directory "D: / ORADATA /" below. Repeat this step if you move multiple files.
<3> Enter the command window, press the following: C: / SVRMGRL (Enter) SVRMGR> Connect Internal (Enter) SVRMGR> Startup Mount (Enter) # Waiting for Database Tips Signs SVRMGR> ALTABASE RENAME FILE 'C : /Ora8/oradata/oracle/Users01.dbf 'to' d: /oradata/users01.dbf '; # 提 提 语 已 Process, if you want to move multiple files, modify the file path and name, repeat the statement above. Open the database after completion. SVRMGR> ALTER DATABASE Open; SVRMGR> EXIT
The database file is successful.
Note: The above blue tilt font is the manual input of the operator, where the file path and the name are actually subjective, please flexibly modify.
