reducing datafiles free space [message #243822] |
Sat, 09 June 2007 07:06 |
khosravi
Messages: 68 Registered: April 2006
|
Member |
|
|
hello
if i have free space in datafiles, is using ALTER DATABASE statement and DATAFILE RESIZE clause for reducing size of datafiles good idea?
and what views i can use for defining free space of datafiles? please write the query
thanks
|
|
|
|
Re: reducing datafiles free space [message #243830 is a reply to message #243826] |
Sat, 09 June 2007 10:42 |
khosravi
Messages: 68 Registered: April 2006
|
Member |
|
|
hello Michel Cadot
i use oracle 10g and in this release through web console enterprise
manager i can understand how mach free space is available in every
datafile but i want define datafiles free space through catalog views
and i want reduce datafiles free space for saving disk capacity
can you guide me ?
thanks
|
|
|
|