Oracle Database Table Space Migration

The disk of the Oracle installation directory is fully stretched, causing the Oracle database to hang, querying the Internet for a solution that is divided into two ways:

One, mobile table space files

1, modify the table space offline state

ALTER tablespace ts_partition_000 OFFLINE;

2, copy the table space corresponding file to a new location

cp/opt/oracle/11g/dbs/ts_partition_000/oradata/dtcdb/tbs/ts_partition_000

3, modify the table space data file path

ALTER tablespace ts_partition_000 RENAME datafile '/opt/oracle/11g/dbs/ts_partition_000 ' to '/oradata/dtcdb/tbs/ts_ partition_000 ';

4, modify the table space for online status

ALTER tablespace ts_partition_000 ONLINE;

5, delete the table space corresponding to the original database file

rm-rf/opt/oracle/11g/dbs/ts_partition_000

Second, move the database file

1. Close the database

SHUTDOWN IMMEDIATE;

2. Copy database files

Cp/opt/oracle/11g/dbs/dbfile.dbf/oradata/dtcdb/tbs/dbfile.dbf

3, hook up the way to start the database

Startup Mount

4, modify the database file path

ALTER DATABASE RENAME FILE '/opt/oracle/11g/dbs/dbfile.dbf ' to '/oradata/dtcdb/tbs/dbfile.dbf ';

5, open the database

ALTER DATABASE OPEN;