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>;
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.