Oracle table Spatial Data File transfer method ____oracle

Bywhhuang question:

Oracle installed to the root directory, the root directory is not enough space, add a hard drive mount to the home, the table space to transfer data files to the home directory.

Hard disk Format

The newly added hard drive needs to be formatted. The method is as follows:

To view the partition format:

[Root@centos iavp]# df-th

FileSystem Type Size Used avail use% mounted on

/dev/vda2 ext4 53G 33G 18G 65%/

Tmpfs tmpfs 4.2G 0 4.2G 0%/dev/shm

/DEV/VDA1 ext4 204M 27M 167M 14%/boot

/dev/vdd ext4 53G 33G 18G 65%/

/dev/vdd ext4 212G 16G 185G 8%/home

format:

#mfks-T EXT4/DEV/VDD

Mount:

# Mount/dev/vdd/home

Note: If a busy error is raised, execute the following command:

#fuser-km/home Transfer Method

Log on to the server using the root account

1, the new mount of the home directory to assign permissions

#chmod-R 777/home

Use the Oracle account to log on to the server below

2, the table space offline processing

Alter tablespace ms50testlogs offline;

3. Transfer table space file

CP/OPT/ORACLE/ORADATA/IAVP/MS50TESTLOGS_DATA.DBF ms50testlogs_data.dbf

3, use the Oracle account login server, use command sqlplus/as SYSDBA login Oracle database, execute transfer SQL

Altertablespace Ms50testlogs

Renamedatafile

'/OPT/ORACLE/ORADATA/IAVP/MS50TESTLOGS_DATA.DBF '

To

'/HOME/ORACLE/MS50TESTLOGS_DATA.DBF ';

4. Execute Recover command

Alterdatabaserecoverdatafile '/home/oracle/ms50testlogs_data.dbf ';

5, the table space online processing

Alter tablespace Ms50testlogs Online;