Re: TableSpace / Datafiles resize

From: rs <info_at_bytelife.com>
Date: Wed, 9 Jul 2003 21:17:52 +0200
Message-ID: <3f0c6a62$0$45387$1b62eedf@news.wanadoo.nl>

hello Rath,

Just run the frag.sql from http://www.bytelife.com/sql4dba.htm to find out what's there, then move or rebuild it.

gool luck

Roelof

R. Schierbeek, DBA

"Rath.Yelandur" <Rath.Yelandur_at_Say.No.To.Spam> schreef in bericht 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 Received on Wed Jul 09 2003 - 14:17:52 CDT