oracle表空间更换路径,Oracle表空间切换路径，解决硬盘满导致的ORA-01653问题

**问题**

```bash

ORA-1653: unable to extend table CAMS_CORE.BP_E_JOURNAL_DATA by 128 in tablespace CAMS_CORE_TAB

ORA-1653: unable to extend table CAMS_CORE.BP_E_JOURNAL_DATA by 1024 in tablespace CAMS_CORE_TAB

```

**解决方案**

```bash

查看表空间文件大小及路径

select * from dba_data_files;

将部分表空间offline

alter tablespace CAMS_CORE_TAB offline;

alter tablespace CAMS_CORE_IDX offline;

alter tablespace CAMS_CORE_LOB offline;

创建临时存放表空间文件的路径

mkdir -p /app/oracle/tablespace/

mv /home/oracle/cams/tablespace/CAMS_CORE_*.dbf /app/oracle/tablespace/

修改表空间的路径

alter tablespace CAMS_CORE_IDX rename datafile '/home/oracle/cams/tablespace/CAMS_CORE_IDX_001.dbf' to '/app/oracle/tablespace/CAMS_CORE_IDX_001.dbf';

alter tablespace CAMS_CORE_LOB rename datafile '/home/oracle/cams/tablespace/CAMS_CORE_LOB_001.dbf' to '/app/oracle/tablespace/CAMS_CORE_LOB_001.dbf';

alter tablespace CAMS_CORE_TAB rename datafile '/home/oracle/cams/tablespace/CAMS_CORE_TAB_001.dbf' to '/app/oracle/tablespace/CAMS_CORE_TAB_001.dbf';

将相关表空间online

alter tablespace CAMS_CORE_TAB online;

alter tablespace CAMS_CORE_IDX online;

alter tablespace CAMS_CORE_LOB online;

查看表空间最新路径

select * from dba_data_files;

```

结果图片****


经过验证，应用程序恢复正常，数据库恢复正常！

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31394774/viewspace-2375255/，如需转载，请注明出处，否则将追究法律责任。