The general procedure for moving a database file is:1. Shut down the database2. Use the operating system to copy the file(s) to their new location. (on UNIX don't move them with the mv command, use cp or dd)3. Using SVRMGR issue the CONNECT INTERNAL command to connect to the database.4. Using SVRMGR MOUNT the database, but don't OPEN it.5. Issue the ALTER DATABASE command to rename the file.ALTER DATABASE database name
RENAME FILE 'OLD FILE NAME' TO 'NEW FILE NAME';Note: The database name will default to the initialization parameter DB_NAME if not specified.6. Shutdown and restart the database.7. Use SVRMGR or SQLPLUS to look at the view DBA_DATA_FILES to be sure the file is renamed.8. Delete the old file via the appropriate operating system command. (Be sure the database is started before you delete the file, if the database is running it will prevent you from deleting files that are still active on VMS and NT. On UNIX use the "fuser" command against the file to see if it is active.)To rename the SYSTEM tablespace or rename multiple tablespaces at one time you must do the following:1. Shutdown the database, backup.2. Alter the database mounted but not open.3. Copy the data file(s) to its new location.4. Use ALTER DATABASE to rename the datafile(s).5. Alter the database open.6. Alter the database to backup the control file.7. Delete the old file(s).8. Shutdown and backup the database.
RENAME FILE 'OLD FILE NAME' TO 'NEW FILE NAME';Note: The database name will default to the initialization parameter DB_NAME if not specified.6. Shutdown and restart the database.7. Use SVRMGR or SQLPLUS to look at the view DBA_DATA_FILES to be sure the file is renamed.8. Delete the old file via the appropriate operating system command. (Be sure the database is started before you delete the file, if the database is running it will prevent you from deleting files that are still active on VMS and NT. On UNIX use the "fuser" command against the file to see if it is active.)To rename the SYSTEM tablespace or rename multiple tablespaces at one time you must do the following:1. Shutdown the database, backup.2. Alter the database mounted but not open.3. Copy the data file(s) to its new location.4. Use ALTER DATABASE to rename the datafile(s).5. Alter the database open.6. Alter the database to backup the control file.7. Delete the old file(s).8. Shutdown and backup the database.
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货