Home » RDBMS Server » Performance Tuning » Moving table into same tablespace (oracle9i)
Moving table into same tablespace [message #321054] Sun, 18 May 2008 20:28 Go to next message
shrinika
Messages: 266
Registered: April 2008
Senior Member
Dear all,

Moving table from one tablespace to same tablespace will reset the HWM. But my clarification here is, when we move into same tablesapce, does oracle move different location in the same tablesapace?? What is the actual process when we move into same tablespace?? I appriciate if any one clarify this..


Thanks
Re: Moving table into same tablespace [message #321055 is a reply to message #321054] Sun, 18 May 2008 20:41 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>does oracle move different location in the same tablesapace??
If you'd query DBA_EXTENTS before & after "moving" within same tablespace, you could answer this question.
Re: Moving table into same tablespace [message #321586 is a reply to message #321055] Tue, 20 May 2008 15:20 Go to previous message
shrinika
Messages: 266
Registered: April 2008
Senior Member
Thanks !!!
Previous Topic: cursor: pin S wait on X in Oracle 10.2.0.4
Next Topic: Updates
Goto Forum:
  


Current Time: Tue Dec 06 06:26:35 CST 2016

Total time taken to generate the page: 0.09196 seconds