Home » RDBMS Server » Server Administration » reducing datafiles free space
reducing datafiles free space [message #243822] Sat, 09 June 2007 07:06 Go to next message
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 #243826 is a reply to message #243822] Sat, 09 June 2007 08:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Weird, how do you know you have free space if you don't know to see what free space you have?
Quote:
is using ALTER DATABASE statement and DATAFILE RESIZE clause for reducing size of datafiles good idea

I don't know another simple way to do it.

But the question is: why do you want to resize your datafile?

Regards
Michel


Re: reducing datafiles free space [message #243830 is a reply to message #243826] Sat, 09 June 2007 10:42 Go to previous messageGo to next message
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
Re: reducing datafiles free space [message #243832 is a reply to message #243830] Sat, 09 June 2007 12:05 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ dba_free_space
2/ Are you sure you'll never need this space?

Regards
Michel
Previous Topic: patch file for 10g
Next Topic: database time
Goto Forum:
  


Current Time: Sat Dec 03 16:27:22 CST 2016

Total time taken to generate the page: 0.08033 seconds