You may need to extend a segment if the database object or objects assigned to the segment run out of space. sp_extendsegment extends the size of a segment by including additional database devices as part of an existing segment. The syntax is:
sp_extendsegment segname, dbname, devname
Before you can extend a segment:
The database device must be listed in sysdevices,
The database device must be available in the desired database, and
The segment name must exist in the current database.
The following example adds the database device pubs_dev2 to an existing segment named bigseg:
sp_extendsegment bigseg, pubs2, pubs_dev2
To extend the default segment in your database, you must place the word “default” in quotes:
sp_extendsegment "default", mydata, newdevice
