OraFAQ Forum: Performance Tuning » Moving table into same tablespace

Home » RDBMS Server » Performance Tuning » Moving table into same tablespace (oracle9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Moving table into same tablespace [message #321054]

Sun, 18 May 2008 20:28

shrinika
Messages: 306
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

Report message to a moderator

Re: Moving table into same tablespace [message #321055 is a reply to message #321054]

Sun, 18 May 2008 20:41

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Moving table into same tablespace [message #321586 is a reply to message #321055]

Tue, 20 May 2008 15:20

shrinika
Messages: 306
Registered: April 2008

Senior Member

Thanks !!!

Report message to a moderator

Previous Topic:	cursor: pin S wait on X in Oracle 10.2.0.4
Next Topic:	Updates

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 01:30:39 CST 2024