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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 ? |
| ||||
| 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 |