Skip to main content

EXP-00056: ORACLE error 25153 encountered ORA-25153: Temporary Tablespace is Empty

Did you get the above error when trying to use exp command in Oracle..?


#### HOW to solve it.

## To check the default temporary tablespace of the database:
SQL> select property_name, property_value from database_properties;

## check DEFAULT_TEMP_TABLESPACE, if it use wrong temporary tablespace, run:
SQL> alter database default temporary tablespace temp;

## check user with temporary tablespace, run command:
SQL> select username, temporary_tablespace, account_status from dba_users;

## change temporary tablespace:
SQL> create temporary tablespace temp1 tempfile '/data/u01/app/oracle/oradata/TIS/temp_b.dbf' size 100m;

SQL> alter database default temporary tablespace temp1;

SQL> drop tablespace temp including contents and datafiles;

SQL> create temporary tablespace temp tempfile '/data/u01/app/oracle/oradata/TIS/temp01.dbf' size 100m autoextend off extent management local uniform size 1m;

SQL> alter database default temporary tablespace temp;

SQL> drop tablespace temp1 including contents and datafiles;


Comments

  1. It works! Thank you very much

    ReplyDelete
  2. Thank You and that i have a keen offer: How Much House Renovation Cost house and renovation show

    ReplyDelete

Post a Comment

Popular posts from this blog

Setting ORACLE_SID

The  Oracle System ID  ( S ID ) is used to uniquely identify a particular database on a system How to set ORACLE_SID: Windows: set ORACLE_SID=orcl Unix/ Linux: export ORACLE_SID=orcl SID is case sensitive in Unix / Linux environments. How to check the current ORACLE_SID: Windows: Go to the commnand prompt and type as C:\> set ORACLE_SID (This will show if any ORACLE_SID is already set). C:\> set (To know all the parameters set) Unix/ Linux: echo $ORACLE_SID