CREATE TEMPORARY TABLESPACE

ORA-01187: cannot read from file because it failed verification tests

How to Resolve ORA-01187: cannot read from file

by Ed Chen
September 12, 2022March 20, 2023

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-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 »

Create Temporary Tablespace Examples

by Ed Chen
August 23, 2022February 12, 2023

Normally, we don't create additional temporary tablespace, because there's already a default one. For some reason, we need to create one for assigning the temporary… 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 »

Alter Temporary Tablespace Correctly

by Ed Chen
February 15, 2020February 12, 2023

Some statements about temporary tablespaces are NOT valid to perform. Create a Temporary Tablespace You can't create a temporary tablespace like a normal, permanent tablespace.… Read More »

How to Resolve ORA-25153: Temporary Tablespace is Empty

by Ed Chen
March 14, 2015March 20, 2023
2 Comments

ORA-25153 After activating a physical standby database, I found some SQL statements returned ORA-25153: Description ORA-25153: Temporary Tablespace is Empty Cause An attempt was made… Read More »