I am working on a database on which the temporary tablespace
databfile(1 datafile only) is autoextensible.After executing a large
process the file grew to 9 GB. I added another file to the same
tablespace of size 100M .The new file got 100% filled up (saw it using
TOAD) .Now i remove the file of 9GB size .Add another file of 2 GB
(where autoextensible is no )and remove the smaller file of size
100m.Now when i see the space usage of 2GB file using TOAD it is
100%.How can this be possible.Because I have removed the file of 9 GB
,used intermediate file of 100M and then finally used a file of
2GB.The space usage in the 2GB file should be at most 100M.
I am working on 9.2.0.5.
Received on Tue Jul 26 2005 - 09:40:11 CDT
