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
dedwalker
Messages: 2
Registered: December 2006
Location: Darwin, NT, Australia
Junior Member

Hi, a request for facts here;

On a data warehouse DB (Oracle 10.2.0.1.0), 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: Thu Dec 08 14:40:10 CST 2016

Total time taken to generate the page: 0.06697 seconds