BhaviSavla wrote:I tried to research regarding the same on the internet and the only working solution I could find is to create a new temp file for the temporary tablespace. I already have more than 3 temp files and still require to to add a fourth one to rectify this error.
EXP-00008: ORACLE error 25153 encountered
ORA-25153: Temporary Tablespace is Empty
BhaviSavla wrote:From which user you are performing expdp? Is this users temporary tablespace has tempfiles associated?
I already have a temp tablespace which contains 3 tempfiles!!!!
SQL> select username,temporary_tablespace from dba_users where username='&user';