**问题** ```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; ``` 结果图片****  经过验证，应用程序恢复正常，数据库恢复正常！