Shulou(Shulou.com)06/01 Report--

1 the status of the data file is set to offline

Set the tablespace to offline

SQL > select file_name,tablespace_name from dba_data_files

SQL > alter tablespace users offline

SQL > select name,status from v$datafile

NAME STATUS

/ u01/app/oracle/oradata/ORA11GR2/system01.dbf SYSTEM

/ u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf ONLINE

/ u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf ONLINE

/ u01/app/oracle/oradata/ORA11GR2/users01.dbf OFFLINE

/ u01/app/oracle/oradata/ORA11GR2/example01.dbf ONLINE

2 complete the real renaming operation at the operating system level

3 modify the data file name at the database level

Alter database rename file'/ u01GR2 to'/ u01qapplash ORA11GR2 / users 01.dbf'oradata'/ u01qqappr

4 the tablespace is reset to online state

Alter tablespace users online

SQL > select name,status from v$datafile

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.