TEMP

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-03217: invalid option for alter of TEMPORARY TABLESPACE

by Ed Chen
February 12, 2020October 10, 2021

ORA-03217 ORA-03217 means that the statement looks syntactically correct, but the action you performed is invalid for a temporary tablespace. Let's check the content of… 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 »

How to Resolve ORA-01652: unable to extend temp segment by 8192 in tablespace

by Ed Chen
May 31, 2014November 13, 2021

ORA-01652 or ORA-1652 1. Permanent Tablespace SQL> INSERT INTO ERP35.PAY_HIST SELECT * FROM ERP35.PAY_TRANS; INSERT INTO ERP35.PAY_HIST SELECT * FROM ERP35.PAY_TRANS; * ERROR at line… Read More »