Re: TableSpace / Datafiles resize

From: michael ngong <mngong_at_yahoo.com>
Date: 9 Jul 2003 10:56:47 -0700
Message-ID: <ecf365d5.0307090956.45553079@posting.google.com>

"Rath.Yelandur" <Rath.Yelandur_at_Say.No.To.Spam> wrote in message news:<3f0bf877$1_at_shknews01>...
> 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
> ?

It is not possible to resize when space is in use 20% of 2G will be 400M .This makes it logical, at least from the information you presented that resizing to 100M should fail

Michael Tubuo Ngong Received on Wed Jul 09 2003 - 12:56:47 CDT