Home » RDBMS Server » Server Administration » datafile resize (oracle 10g in AIX)
datafile resize [message #389231] Fri, 27 February 2009 12:58 Go to next message
Messages: 226
Registered: March 2007
Senior Member
I have oracle 10g with ASM running on AIX unix. I over allocated space in one of the tablespace and wanted to resize the data file. But before doing that I want to know the High Water Mark and resize the datafiles accordingly. Can someone tell me how to find the HWM and how to calculate the size based on HWM?
Re: datafile resize [message #389233 is a reply to message #389231] Fri, 27 February 2009 13:07 Go to previous message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator

Find the allocated size of the datafile.
Find how much much space is used within the datafile.
You can only shrink to a size somewhat above the size used.
Search the forum. All these are asked and answered numerous times.
The method may may vary depending on type of tablespace management.

[Updated on: Fri, 27 February 2009 13:11]

Report message to a moderator

Previous Topic: "ORA-27102: out of memory" and SGA
Next Topic: Tablespace error
Goto Forum:

Current Time: Thu Jul 27 00:21:37 CDT 2017

Total time taken to generate the page: 0.16329 seconds