Space - Temp Table Space Is Empty
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Space - Temp Table Space Is Empty as PDF for free.
More details
- Words: 61
- Pages: 2
How to solve ORA-25153 : Temporary Tablespace is Empty
The problem occurred when : 1) no datafile defined for temporary tablepsace 2) if datafile existed, set it as default temporary
How to solve problem (1) : 1) create temporary tablespace psaptmp tempfile '/oracle/TCC/sapdata3/tmp_1/tmp.data1' size 1000M autoextend on next 500M maxsize 5000M extent management local 2) alter database default temporary tablespace psaptmp
The problem occurred when : 1) no datafile defined for temporary tablepsace 2) if datafile existed, set it as default temporary
How to solve problem (1) : 1) create temporary tablespace psaptmp tempfile '/oracle/TCC/sapdata3/tmp_1/tmp.data1' size 1000M autoextend on next 500M maxsize 5000M extent management local 2) alter database default temporary tablespace psaptmp
Related Documents
Space - Temp Table Space Is Empty
November 2019 4
Table Space Usage
May 2020 3
Transportable Table Space Refresh
November 2019 8
Space
June 2020 30
Space
June 2020 25