Switch the path of Oracle table space to solve the ORA-01653 problem caused by full hard disk

problem

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

Solution

View the tablespace file size and path select * from dba_data_files; will part of the tablespace offlinealter tablespace CAMS_CORE_TAB offline;alter tablespace CAMS_CORE_IDX offline;alter tablespace CAMS_CORE_LOB offline Create a path to temporarily store tablespace files mkdir-p / app/oracle/tablespace/mv / home/oracle/cams/tablespace/CAMS_CORE_*.dbf / app/oracle/tablespace/ modify the path to 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'; will correlate the tablespace onlinealter tablespace CAMS_CORE_TAB online;alter tablespace CAMS_CORE_IDX online;alter tablespace CAMS_CORE_LOB online View the latest path to the table space select * from dba_data_files

Result picture * *

After verification, the application program returns to normal and the database returns to normal!