1 Version 4.0 -- 1/15/89 sp_placeobject
______________________________________________________________________
NAME: sp_placeobject
FUNCTION:
Put future space allocations for a table or index on a particular
segment.
SYNTAX:
sp_placeobject segname, objname
EXAMPLES:
sp_placeobject indexes, 'employee.employee_nc'
sp_placeobject Version 4.0 -- 1/15/89 2
______________________________________________________________________
This command causes all subsequent data for the index named
employee_nc on table employee to be placed on the segment named
indexes.
PARAMETERS:
segname - is the name of the segment where the table or index is
to be located.
objname - is the name of the table or index whose subsequent
space allocation is to be placed on the segment segname.
COMMENTS:
o Placing a table or index on a particular segment does not
affect the location of any existing table or index data. It
only affects data that is added subsequently. By changing the
segment used by a table or index, the data can be spread around
3 Version 4.0 -- 1/15/89 sp_placeobject
______________________________________________________________________
multiple segments.
o When a table or index is created using the CREATE TABLE or
CREATE INDEX command you can specify a segment. If no segment
is specified the data will go on the default segment.
o When the data for a table or index has been split among more
than one disk fragment, the diagnostic command DBCC will com-
plain about data that resides on fragments previously refer-
enced by the segment. These can be ignored.
MESSAGES:
The command was successful. Data for the objname will now be put
onto the segment segname.
The segname you have referenced is not a segment. All segments
for a database are listed in the syssegments table.
Only the table owner, the Database Owner, or the System Adminis-
trator may place a table or its index on a segment.
sp_placeobject Version 4.0 -- 1/15/89 4
______________________________________________________________________
The index referenced in the objname parameter does not exist.
Use the stored procedure sp_help to list the indexes of a
table.
PERMISSIONS:
Execute permission to the table owner, Database Owner, and System
Administrator.
TABLES USED:
syssegments, sysobjects, sysindexes
SEE ALSO:
sp_addsegment, sp_extendsegment, sp_dropsegment, sp_help