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

问题

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

解决方案

查看表空间文件大小及路径select * from dba_data_files;将部分表空间offlinealter 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';将相关表空间onlinealter tablespace CAMS_CORE_TAB online;alter tablespace CAMS_CORE_IDX online;alter tablespace CAMS_CORE_LOB online;查看表空间最新路径select * from dba_data_files;

结果图片 **

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