What is the error when you try to resize?

If you use the file number instead of using the complete filename, you could
run into problems.

-----Original Message-----
From: ganesh.[Email Address Removed] [mailto:ganesh.[Email Address Removed] Friday, May 31, 2002 5: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