Monday, March 28, 2011

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;


2 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