OraFAQ Forum: Server Administration » enable/ disable row movement

Home » RDBMS Server » Server Administration » enable/ disable row movement

Thu, 20 October 2011 04:14

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;

Thu, 20 October 2011 04:38

Michel Cadot
Messages: 54247
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You don't need it, you can do it.

Regards
Michel

Thu, 20 October 2011 05:18

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?

??

Thu, 20 October 2011 05:28

Michel Cadot
Messages: 54247
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: Sat May 25 20:39:27 CDT 2013

Total time taken to generate the page: 0.07421 seconds