OraFAQ Forum: Server Administration » Export Utility gives errors "Temporary Tablespace empty"

Home » RDBMS Server » Server Administration » Export Utility gives errors "Temporary Tablespace empty"

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export Utility gives errors "Temporary Tablespace empty" [message #64062]

Sat, 11 December 2004 00:23

Chandan Singh Bhamra
Messages: 1
Registered: December 2004

Junior Member

I am running Export Utility but when it runs gives errors "Temporary Tablespace Empty". What could be the reason for giving this error ?

Regards

Chandan Singh

�

�

Report message to a moderator

Re: Export Utility gives errors "Temporary Tablespace empty" [message #64063 is a reply to message #64062]

Sat, 11 December 2004 00:28

dilip kumar
Messages: 111
Registered: December 2003

Senior Member

Hi

which version your using and pls post the exact error msg...

the reason for this error temporary segments has not cleaned up properly it seems...

create a another temporary tablespace and assigned this tablespace as a default temporary tablespace for your current instance...this will work...

regards

D.Dilip

Report message to a moderator

Re: Export Utility gives errors "Temporary Tablespace empty" [message #64064 is a reply to message #64063]

Sat, 11 December 2004 03:27

Nino
Messages: 6
Registered: November 2004

Junior Member

Hi,

I agree with Dilip. No sort segment could be allocated or something like that.
You cann create a new temporary tablespace and set it to default:
create temporary tablespace <temptbl> tempfile 'file' size ... ;
alter database default temporary tablespace <temptbl>;

or if you already have have a temporary tablespace sed to default, then it probably has no tempfile assigned.

select * from database_properties where property_name = ('DEFAULT_TEMP_TABLESPACE');

check out in the v$tempfile and v$tablespace the tempfile assignment to the temporary tablespace. You can check the v$sort_segment as well.

Hope I could help
Nino

Report message to a moderator

Re: Export Utility gives errors "Temporary Tablespace empty" [message #64090 is a reply to message #64062]

Tue, 14 December 2004 01:15

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Sometimes after an Restore or other rebuild operations the Temporary tablespace lost its Datafile.
take a look into DBA Studio and take care that the temp has its tempfile. It is stil on Disc, but missing for oracle.
Simple adding the old file to the tablespace will help than.

regards
Uwe

Report message to a moderator

Previous Topic:	how to convert oracle table data into text file
Next Topic:	no repostory & service name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 23:20:03 CST 2025