Home » RDBMS Server » Server Administration » enable/ disable row movement
enable/ disable row movement [message #527799] Thu, 20 October 2011 04:14 Go to next message
hanner
Messages: 90
Registered: August 2011
Location: at HOME
Member
for defragment of a table,

after enable it:

alter table test enable row movement;


do i need to:

alter table test disable row movement;


??
Re: enable/ disable row movement [message #527806 is a reply to message #527799] Thu, 20 October 2011 04:38 Go to previous messageGo to next message
Michel Cadot
Messages: 59821
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't need it, you can do it.

Regards
Michel
Re: enable/ disable row movement [message #527810 is a reply to message #527806] Thu, 20 October 2011 05:18 Go to previous messageGo to next message
hanner
Messages: 90
Registered: August 2011
Location: at HOME
Member
Michel Cadot wrote on Thu, 20 October 2011 17:38
You don't need it, you can do it.

Regards
Michel



you mean i can no need to enable it back?

??
Re: enable/ disable row movement [message #527814 is a reply to message #527810] Thu, 20 October 2011 05:28 Go to previous message
Michel Cadot
Messages: 59821
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, this is what I mean.

Regards
Michel
Previous Topic: err01033:oracle initialization or shutdown in progress
Next Topic: archive log generation time interval or size wise
Goto Forum:
  


Current Time: Fri Nov 28 12:17:00 CST 2014

Total time taken to generate the page: 0.12799 seconds