How Oracle Rename DataFile
Rename DataFile The procedure of renaming an Oracle datafile is actually the same as the procedure of moving datafile with a different file name. Let's… Read More »How Oracle Rename DataFile
ALTER TABLESPACE ONLINE
How to Resolve ORA-01641: tablespace is not online - cannot add data file
ORA-01641 Tried to add a data file to a tablespace, but it failed with ORA-01641. SQL> alter tablespace example add datafile '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB/example01.dbf' size 10m autoextend… Read More »How to Resolve ORA-01641: tablespace is not online - cannot add data file
How to Resolve ORA-01542: tablespace is offline, cannot allocate space in it
ORA-01542 Tried to move a table to another tablespace, but we got ORA-01542. SQL> alter table employees move tablespace users online; alter table employees move… Read More »How to Resolve ORA-01542: tablespace is offline, cannot allocate space in it
How to Resolve ORA-01157: cannot identify/lock data file
ORA-01157 Saw error ORA-01157 when we tried to bring a tablespace online. SQL> alter tablespace example online; alter tablespace example online * ERROR at line… Read More »How to Resolve ORA-01157: cannot identify/lock data file
Switch Tablespace To Copy
Move Tablespace by RMAN No like we move individual data file to another place by RMAN, changing the location of a tablespace by RMAN is… Read More »Switch Tablespace To Copy
Alter Database Rename File
Move Data File Offline Not like the new released statement ALTER DATABASE MOVE DATAFILE which can move data files online, the old-fashioned file renaming procedure… Read More »Alter Database Rename File