dbTalk Databases Forums  

TableSpace / Datafiles resize

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss TableSpace / Datafiles resize in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rath.Yelandur
 
Posts: n/a

Default 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
?



Reply With Quote
  #2  
Old   
philippe
 
Posts: n/a

Default Re: TableSpace / Datafiles resize - 07-10-2003 , 03:58 AM






To help you You can use "Oracle Tool" on
http://membres.lycos.fr/pmscontact/
This tool tell you how tablespaces are used and to the tables/db
objects that are allocated in tablespaces.

This tool is free
see "administration / TableSpace's Objects" tab for these informations

regards
Philippe

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.