Temp File

How to Resolve ORA-02231: missing or invalid option to ALTER DATABASE

by Ed Chen
December 22, 2022December 28, 2022

ORA-02231 ORA-02231 means that a keyword is missing from the position where it should be in ALTER DATABASE statement. Most likely, it's a syntax error.… Read More »

Alter Database Move Tempfile?

by Ed Chen
November 25, 2022October 26, 2022

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 »

How to Resolve ORA-01135: file accessed for DML/query is offline

by Ed Chen
November 23, 2022December 12, 2022

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 Oracle Rename TempFile

by Ed Chen
October 21, 2022December 28, 2022

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 »

Alter Database Rename File

by Ed Chen
May 16, 2016October 15, 2022

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 »