temp

How to add a tempfile in primary database in dataguard

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

ORA-12910: cannot specify temporary tablespace as default tablespace

PROBLEM: While assigning default tablespace for a user, got an ORA-12910 error. [crayon-5beb0edf9f2eb830447973/] SOLUTION: As the error says, we can’t set a temporary tablespace as default table...

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 [crayon-5beb0edf9ff4...

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. [crayon-5beb0edfa0938662736772/]

Skip to toolbar