Move index-segment

#41

On Oct 22, 9:51*am, "Heinz Müller" <onkelhe... (AT) mscologne (DOT) de> wrote:

Quote:

"Bret_Halford" <b... (AT) sybase (DOT) com> schrieb im Newsbeitragnews:84469fed-2f7d-4824-b3ac-102977c36eff (AT) j22g2000hsf (DOT) googlegroups.com...
On Oct 21, 9:07 am, "Heinz Müller" <onkelhe... (AT) mscologne (DOT) de> wrote:

"Bret_Halford" <b... (AT) sybase (DOT) com> schrieb im
Newsbeitragnews:097cf71e-4a70-49c9-9701-288b0dbb7402 (AT) u40g2000pru (DOT) googlegroups.com...
On Oct 20, 11:00 am, "Heinz Müller" <onkelhe... (AT) mscologne (DOT) de> wrote:

Yes, you would use sp_extendsegment to move the segment onto the new
device, and
sp_dropsegment to remove it from the original device.
You may then want to rebuild any indexes assigned to that segment to
get their actual
space allocation to move onto the new device.

Bret,

thank you.

My colleage has solved it with sp_placeobject. But I'm wondering how he did that,
because the description of sp_placeobject tells that it is only for future space
allocation.

I'll ask him tommorrow.

Heinz
Are you wanting to move the index's allocation from one device to
another,
as opposed to just moving the segment?
-bret

Yes, *the index's allocation should move to a new device,
because as my colleage said, there is a part on a data device named data_dev
and it should move on ind_dev. In the past the ind_dev was full and so hetook
a part of data_dev also for index's. Now the ind_dev is big enough and he
wants to move it from data_dev to ind_dev. Very confusing for me..

But I'm not in the office today, so I'll ask him on thursday.

Heinz

In that case he will want to rebuild the index once the segment has
been
moved to the desired device and removed from the undesired device.

-bret

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Move index-segment

comp.databases.sybase comp.databases.sybase

Re: Move index-segment - 10-23-2008 , 01:21 PM