Move Temp File Online? We have talked about moving a data file online in the previous post and we're thinking about moving a temp file… Read More »Alter Database Move Tempfile?
Rename TempFile Earlier, we have talked about how to rename a datafile, now how about tempfile? How to rename it? The procedure of renaming an… Read More »How Oracle Rename TempFile
ORA-01187 Found ORA-01187 and ORA-01110 after activating a standby database. ORA-01187: cannot read from file because it failed verification tests ORA-01110: data file 2003: '+DATA/ORCLCDB/ORCLPDB/temp01.dbf'… Read More »How to Resolve ORA-01187: cannot read from file
Resizing a temporary tablespace may have 2 meanings in Oracle, one is to increase its size, the other is to shrink its size. In this… Read More »How Oracle Resize Temp Tablespace
ORA-01516: nonexistent log file, datafile, or temporary file There're two scenarios that throw ORA-01516 going to be introduced in this post. 1. Rename Tempfile I… Read More »How to Resolve ORA-01516 Error Message
Offline a Temporary Tablespace Theoretically, you can't take the whole temporary tablespaces offline. SQL> alter tablespace temp offline; alter tablespace temp offline * ERROR at… Read More »How to Alter Temporary Tablespace Offline