Home » SQL & PL/SQL » SQL & PL/SQL » General Question regarding High Water Mark
General Question regarding High Water Mark [message #193958] Wed, 20 September 2006 02:28 Go to next message
be2sp1
Messages: 52
Registered: September 2005
Location: India
Member
Hi,

Is there a way by which we can reset the High water mark without truncating a table. Also, how does Analyzing a table helps in fast retrieval of data and is there any role of HWM in Analyzing the table.

thanks
Re: General Question regarding High Water Mark [message #193959 is a reply to message #193958] Wed, 20 September 2006 02:30 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You can rebuild the table by using the ALTER TABLE...MOVE to move the table to the tablespace it is currently in.
You'll need to rebuild all the indexes on it afterwards, as all the rowids will have changed.
Re: General Question regarding High Water Mark [message #194015 is a reply to message #193958] Wed, 20 September 2006 07:29 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
In addition to what JRowbottom mentioned, if you need access to the table while adjusting the HWM, you could also use dbms_redifinition. If you are using 10g, you should use "alter table <table_name> shrink space".
Re: General Question regarding High Water Mark [message #194017 is a reply to message #194015] Wed, 20 September 2006 07:49 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
That's my learning experience for the day.
Another reason to move to 10g at somne point soon.
Previous Topic: Forms Error
Next Topic: ORA-01722
Goto Forum:
  


Current Time: Sun Dec 04 19:05:08 CST 2016

Total time taken to generate the page: 0.08112 seconds