If standby_file_management is set to AUTO, as soon as we add a datafile on primary database, same will be created automatically on standby database. But will the same valid for tempfile?? Answer is NO...
temp
ORA-12910: cannot specify temporary tablespace as default tablespace
PROBLEM: While assigning default tablespace for a user, got an ORA-12910 error. SQL> alter user dba_raj default tablespace TEMP; alter user dba_raj default tablespace TEMP * ERROR at line 1: ORA-12...
Tablespace Management in oracle
What is a tablespace and datafile: Tablespace is the primary logic structure of the oracle database. It consists of one or more physical datafiles. Datafiles physical stores database data in storage.(...
ORA-25152: TEMPFILE cannot be dropped at this time
PROBLEM: While dropping a tempfile got the below error. SQL> alter tablespace TEMP drop tempfile ‘/archive/NONPLUG/NONCDB/temp01.dbf’; alter tablespace TEMP drop tempfile ‘/archi...
How to drop and recreate temp tablespace in oracle
If you want to recreate your temp tablespace, then follow below steps. For changing the default tablespace also, below steps can be used. Find the existing temp tablespace details SQL> ; 1* select ...
ORA-25153: Temporary Tablespace is Empty while doing export
While export if you are getting below : . exporting rollback segment definitions . exporting database links . exporting sequence numbers . exporting directory aliases . exporting context namespaces . ...
How to find the temp tablespace usage
Run the below scripts to get the temp tablespace usage. select a.tablespace_name tablespace, d.TEMP_TOTAL_MB, sum (a.used_blocks * d.block_size) / 1024 / 1024 TEMP_USED_MB, d.TEMP_TOTAL_MB - sum (a.us...