Hi,

SYBASE 12.5.4, Solaris 10.

Can anyone give me a hint how to move an index segment from one device to another?
Is it similiar like to move a log segment?

Regards,
Heinz

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.

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.

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.

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.

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.

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.

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.

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_Halford" <bret (AT) sybase (DOT) com> schrieb im Newsbeitrag
news: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:

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