TEMPFILE

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 to Resolve ORA-01258: unable to delete temporary file

by Ed Chen
November 8, 2022March 20, 2023

ORA-01258 We successfully dropped a temporary tablespace with its all files, but we saw some errors like ORA-01258 in the alert log. SQL> drop tablespace… 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 »

How to Resolve ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE

by Ed Chen
September 5, 2022February 12, 2023

ORA-25139 Tried to create a temporary tablespace, but it failed with ORA-25139. SQL> create temporary tablespace temp1 datafile '/u01/app/oracle/oradata/ORCL/temp1_01.dbf' size 10m autoextend on next 10m… Read More »

How to Resolve ORA-02180: invalid option for CREATE TABLESPACE

by Ed Chen
May 19, 2022February 12, 2023

ORA-02180 There're 2 basic patterns of error ORA-02180 in this post: Missing Tablespace Name Missing Keyword A. Missing Tablespace Name If we didn't specifiy the… Read More »

How to Resolve ORA-03297: file contains used data beyond requested RESIZE value

by Ed Chen
October 20, 2021June 8, 2022

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 Move Temp File Location in Oracle

by Ed Chen
February 19, 2020October 28, 2022
4 Comments

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 Start Oracle Database

by Ed Chen
September 28, 2019January 5, 2023

Start Oracle Database To start an Oracle database, you have to know which database you want to start. This includes at least two things, Oracle… Read More »

How to Check Oracle Database Size

by Ed Chen
August 30, 2019December 10, 2022

At least two scenarios that you may need to know the database size. Server upgrade or migration You have to plan the size of storage… Read More »

How RMAN Duplicate 19c Standby Database

by Ed Chen
August 11, 2019February 13, 2023
4 Comments

You don't have to create an empty database on the standby server for building a standby database. In this post, I will show you how… Read More »