TableSpace / Datafiles resize -
07-09-2003
, 06:11 AM
TableSpace USR_DATA had grown to 10 GB. It has 8 datafiles, each more than
2GB.
I have dropped some of the User schemas not in use anymore. Now 3-4
datafiles are 80% free. How can I resize these datafiles to takeup less
Hard Disk Space ?
ALTER DATABASE DATAFILE <DBPATH>\USR_DATA04.dbf RESIZE 100M;
does not work.
How to list the tables/db objects that are allocated in a specific DATAFILE
? |