Extending the Scope of Segments

You may need to extend a segment if the database object or objects assigned to the segment run out of space. sp_extendsegment adds database devices to an existing segment.

Before you can extend a segment:
  • The database device must be listed in sysdevices,

  • The database device must be available to the database you are extending, 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, place the word “default” in quotes:
sp_extendsegment "default", mydata, newdevice 

See the Reference Manual: Procedures.