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

1. Use sys or system to log in to oracle with sysdba privileges

2. Query all tablespaces and the addresses of tablespaces

3. Set the table space to be migrated to offline state.

4. Copy the tablespace files that need to be migrated to the destination folder

5. Modify the table space to be migrated to point to the address

6. Set the table space to be migrated to online state

Such as:

Select * from dba_data_files

Alter tablespace PLUSDEV offline

Copy the / u01/app/oracle/oradata/PLUSDEV/users01.dbf file to / dbdata/plusdev/users01.dbf

Alter database rename datafile'/ u01/app/oracle/oradata/PLUSDEV/users01.dbf'to'/ dbdata/plusdev/users01.dbf'

Alter tablespace PLUSDEV online

Note: problems that may arise:

An error occurred in step 6: the ora-01113 file n needs to be repaired by the media, log in using sys/system in the cmd window, and restore using the recover datafile n; statement.

For example:

Ora-01113 file 2 needs media repair, enter statement: recover datafile 2

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.