Error give you some hint
>>ORA-25153: Temporary Tablespace is Empty
Have you checked you have temporary tablespace, may be you recreate your Db and forget to add temporary datafiles. check it
I created temp. tablespace also, but the same error is coming again & again, what would be the reason,?
means there was no temp earlier?
What is the Error you get after adding temp,can you show the Error Here
You can use the below Query to check the TEMP property, it should return some row
SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';
also check the temporary tablespace for the user which you are using for Export or use the command
alter user x temporary teblespace <temp>;
After creating the temporary tablespace, did you grant access to it to the user running the Data Pump job?
my issue has been resolved, i recreated the database, then consecutively created the temporary tablespace & one non-system tablespace and assigned it to an user and the operation expdp uname/uname full=y completed successfully.
There is no need to create the Db. You only need to do
>>created the temporary tablespace & one non-system tablespace and assigned it to an user
Any way You solved it.
what is the use of temporary tablespace in this regard when assigning to the newly created user, i couldn't able to understand the error, although, i resolved the error,
is it true that temporary tablespace stores sorted data, if PGA becomes full? actually what happens in datapump ? whether the same 'fatal error' possible in normal export ?
One Master Table is created in the schema of the current user running the Pump Dump export or import,and it keeps tracks of detailed information.
and this table required storage which should use the default property of schema like default tablespace and default temporary tablesapce
>>whether the same 'fatal error' possible in normal export ?
From what I remember, any kind of SORTS on the data or metadata that the Data Pump job is exporting/importing will be done in the temporary tablespace. If you are running export and you are downgrading:
expdp version=older_version ...
Then you will need global temporary table to store the downgraded master table in before it is exported.