Custom Search
www.rocket99.com : Technical Guides Sybase Oracle UNIX Javascript


Technical Guides
Sybase
Oracle
UNIX
Javascript




Of Interest

Business Intelligence and Analytics



Oracle Training





Sybase » DDL » DBA »

Moving an object to another segment

     




When databases contain more segments than the usual default, it is
often necessary to move tables between segments.



/* move a table, in its entirety, to the new segment */

drop index 'employee.idx_employee'
go
create clustered index on employee (emp_id) on new_seg
go


/* leave table where it is, but future allocations go to the new segment */

sp_placeobject new_seg , 'employee'
go


/* leave table where it is, but future allocations for the
text column (employee_notes) go to the new segment */

sp_placeobject new_seg , 'employee.temployee'
go

/* leave table where it is, but future allocations for the
text column (resume) go to the new segment */

sp_placeobject new_seg , 'student.tstudent'
go












Sybase : Related Topics

Sybase : DDL : Creating a proxy table
Sybase : DDL : Tables which span multiple segments
Sybase : DDL : Object Permissions

Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site



Get the latest Rocket99 news and tech tips via






Site Index About this Guide to Sybase, Oracle, and UNIX Contact Us Advertise on this site




Copyright © 2016 Stoltenbar Inc All Rights Reserved.