Yep, dropping and recreating the tablespace will do a great job of
defragmenting and the only way to completely remove an unwanted datafile.

Dan Straub
McKesson Information Solutions
541-681-8278
44°03'N 124°55'W
Confidentiality Notice: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.


-----Original Message-----
From: ganesh.[Email Address Removed] [mailto:ganesh.[Email Address Removed] Friday, May 31, 2002 3:29 AM
To: LazyDBA.com Discussion
Subject: Why tablespace not resizing


Hello all,

I have moved all tables and indexes from a tablespace inorder to defragment
it. Now there are 2 datafiles one big and one small. I want to eliminate
the small one, by resizing to a small value BUT SURPRISE..i am not able to
resize even after i coalesced it!!! why?

Whats the way around. if nothing, now the tablespace has no objects, i am
thinking of dropping the tablespace and the datafile and recreating a new
tablespace and datafile. Is it safe enough?

Waiting for your inputs
Ganesh



--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page