Unix Technical Forum

TableSpace / Datafiles resize

This is a discussion on TableSpace / Datafiles resize within the Oracle Miscellaneous forums, part of the Oracle Database category; --> TableSpace USR_DATA had grown to 10 GB. It has 8 datafiles, each more than 2GB. I have dropped some ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database > Oracle Miscellaneous

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-07-2008, 09:52 AM
Rath.Yelandur
 
Posts: n/a
Default TableSpace / Datafiles resize

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
?


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-07-2008, 09:53 AM
philippe
 
Posts: n/a
Default Re: TableSpace / Datafiles resize

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:57 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com