How to Drop Empty Tablespace
In previous post, we have talked about how to identify empty tablespaces for dropping. In that post, we cautiously check the status of the tablespace… Read More »How to Drop Empty Tablespace
ALTER TABLESPACE OFFLINE
How to Resolve ORA-45909: restore, recover or block media recovery may be in progress
ORA-45909 Tried to restore a data file by RMAN, it failed with ORA-45909, ORA-19890 and ORA-19573. RMAN> restore datafile 13; ... ORA-19870: error while restoring… Read More »How to Resolve ORA-45909: restore, recover or block media recovery may be in progress
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
How to Resolve ORA-01539: tablespace is not online
ORA-01539 Tried to offline a tablespace, but it failed with ORA-01539. SQL> alter tablespace example offline; alter tablespace example offline * ERROR at line 1:… Read More »How to Resolve ORA-01539: tablespace is not 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-03217: invalid option for alter of TEMPORARY TABLESPACE
ORA-03217 ORA-03217 means that the statement looks syntactically correct, but the action you performed is invalid for a temporary tablespace. Let's check the content of… Read More »How to Resolve ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
How to Empty an Oracle Database
Empty a Database In my case, a phased out database server is going to transfer to another project team, my job is to remove all… Read More »How to Empty an Oracle Database
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