Total Pageviews

Friday 18 May 2012

ORA-25153: Temporary Tablespace is Empty

Got the following error today when trying to execute full export backup command:
exp system/sys file=full_exp2.dmp log=full_exp2.log full=y consistent=y statistics=none buffer=10000000
EXP-00008: ORACLE error 25153 encountered
ORA-25153: Temporary Tablespace is Empty
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.system_info_exp
EXP-00008: ORACLE error 25153 encountered
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_LOB", line 443
ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 571
ORA-06512: at "SYS.DBMS_SCHED_WINDOW_EXPORT", line 14
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_SCHED_WINDOW_EXPORT.create_exp for object 8879
EXP-00008: ORACLE error 25153 encountered
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_LOB", line 443
ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 571
ORA-06512: at "SYS.DBMS_SCHED_WINDOW_EXPORT", line 14
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_SCHED_WINGRP_EXPORT.create_exp for object 8881
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
EXP-00056: ORACLE error 25153 encountered
ORA-25153: Temporary Tablespace is Empty
EXP-00056: ORACLE error 25153 encountered
ORA-25153: Temporary Tablespace is Empty
EXP-00000: Export terminated unsuccessfully

Solution:

First step is to check for temp tablespace and assosiation with users.

select username, temporary_tablespace, account_status from dba_users where username not like '%SYS%';

If  temporary_tablespace exists (TEMP) move to step2 to check datafiles assosiated with the tablespace as below:

Issue No data File associated with temp tablespace:
SQl>Select file_name from dba_temp_files;
No row selected
As you can see there is no data file associated with Temp tablespace;this is the reason of the issue.

To solve the issue simply add a datafile to the temp tablespace using the below command:

SQL>Alter tablespace Temp ADD TEMPFILE '/Data/Oracle4/oradata/new12/MyTemp.dbf' size 500M;

Check again to confirm:(Issue Resolved)
SQl>Select file_name from dba_temp_files;

output:  '/Data/Oracle4/oradata/new12/MyTemp.dbf' 






1 comment:


  1. Jadwal Tarung Ayam SV388 17 Februari 2019 di Situs Judi Sabung Ayam Online Melalui Agen Resmi Taruhan Sabung Ayam Live Asli Thailand.

    Bandar Sabung Ayam - Minggu, 17 Februari 2019 – Pada Hari Tersebut Akan Di Laksanakan Berbagai Pertandingan Sabung Ayam Secara Live di Arena Sabung Ayam Thailand.

    Untuk Info Lebih Lanjut Bisa Hub kami Di :
    wechat : bolavita
    line : cs_bolavita
    whatsapp : +628122222995
    BBM: BOLAVITA

    ReplyDelete