Home » RDBMS Server » Server Administration » Temporary tablespace VS Temporary datafile question
icon10.gif  Temporary tablespace VS Temporary datafile question [message #209218] Wed, 13 December 2006 18:50
Messages: 2
Registered: December 2006
Location: Darwin, NT, Australia
Junior Member

Hi, a request for facts here;

On a data warehouse DB (Oracle, why is it that the tablespace can show that the temporary tablespaces are 100% empty (Administration Tab, Storage region, Tablepspaces link), but then within (Administration Tab, Storage region, Datafiles link) the Temporary tablespace datafiles show 100% used)? IS it a problem that the tablespace, while empty, has datafiles that show up to be full?

It seems a conundrum to me at the moment.

Thanks in advance, DW

[Updated on: Wed, 13 December 2006 21:01]

Report message to a moderator

Previous Topic: tablespace defrag
Next Topic: Which file is currently being used
Goto Forum:

Current Time: Fri Oct 28 16:53:32 CDT 2016

Total time taken to generate the page: 0.32470 seconds