How to add a tempfile in primary database in dataguard
If standby_file_management is set to AUTO, as soon as we ad...
temp
ORA-12910: cannot specify temporary tablespace as default tablespace
PROBLEM: While assigning defaul...
Tablespace Management in oracle
What is a tablespace and datafile: Tablespace is the primary logic ...
ORA-25152: TEMPFILE cannot be dropped at this time
PROBLEM: While dropping a tempfile got the below...
How to drop and recreate temp tablespace in oracle
If you want to recreate your temp tablespace, th...
ORA-25153: Temporary Tablespace is Empty while doing export
While export if you are getting below : ...
How to find the temp tablespace usage
Run the below scripts to get the temp tablespace usage. selec...