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


Technical Guides
Sybase
Oracle
UNIX
Javascript




After Work

Old Town Social
in Chicago, on North Ave, near Cleveland. Great selection of tap beers.
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent beer selection!


Sybase » DDL » DBA »

Tables which span multiple segments

     




Tables containg large amounts of data (> 2 GB) need to be spread across
several devices, using sp_placeobject. Note that this procedure affects only
future operations - if a table load of more the 2 GB is to be performed, it
would have to be split into two or more stages.


/* Future inserts will reside on data_seg2 */
sp_placeobject 'data_seg2','invoice'
go









Sybase : Related Topics

Sybase : DDL : Creating a proxy table
Sybase : DDL : Object Permissions
Sybase : DDL : Moving an object to another segment

Sybase Web Site
Sybase Mobile Web Site
Oracle 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 © 2010 Stoltenbar Inc All Rights Reserved.