Alter Database Move Tempfile?
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?
Temp File
How to Resolve ORA-01135: file accessed for DML/query is offline
ORA-01135 Some user reported an error ORA-01135 when querying the database. ORA-01135: file 1291 accessed for DML/query is offline ORA-01110: data file 1291: '/u01/app/oracle/oradata/orcl/users01.dbf' ORA-01135… Read More »How to Resolve ORA-01135: file accessed for DML/query is offline
How Oracle Rename 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
How to Resolve ORA-01187: cannot read from file
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
How to Resolve ORA-03297: file contains used data beyond requested RESIZE value
ORA-03297 There're two error patterns of ORA-03297, one is to resize a data file, the other is to shrink a temp file. Resize Data File… Read More »How to Resolve ORA-03297: file contains used data beyond requested RESIZE value
How Oracle Resize Temp Tablespace
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
How to Move Temp File Location in Oracle
As we have talked about how to move a whole Oracle database, it's an offline operation. Here we introduce how to change temp file location… Read More »How to Move Temp File Location in Oracle
How to Resolve ORA-01516 Error Message
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
How to Alter Temporary Tablespace Offline
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
Don't Forget to Add Tempfiles Back After Restoring 9i Database
If your database is 10g onward, you don't have to worry about it, the control file will recreate the tempfiles after database restore, but for… Read More »Don't Forget to Add Tempfiles Back After Restoring 9i Database