ASE : How do I move tempdb off of the Master Device?

To drop the master device from the segments:

Alter pubs2 onto another device, if you have not already done so. For example:

alter database pubs2 on pubs2_data = 20

Issue a use sp_dropsegment command, and then drop the master device from the segments: sp_dropsegment "default", pubs2, master sp_dropdegment system, pubs2, master sp_dropdegment logsegment, pubs2, master

To verify that the default segment no longer includes the master device, issue this command: select dbid, name, segmap from sysusages, sysdevices <span style="color:rgb(51,51,51);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13.524px;font-weight:normal;line-height:20.286px;">where sysdevices.low <= sysusages.size + vstart <span style="color:rgb(51,51,51);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13.524px;font-weight:normal;line-height:20.286px;">and sysdevices.high >= sysusages.size + vstart -1 <span style="color:rgb(51,51,51);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13.524px;font-weight:normal;line-height:20.286px;">and dbid = 4 <span style="color:rgb(51,51,51);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13.524px;font-weight:normal;line-height:20.286px;">and (status = 2 or status = 3)

<span style="color:rgb(51,51,51);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13.524px;font-weight:normal;line-height:20.286px;">The segmap column should report "1" for any allocations on the master device, indicating that only the system segment still uses the device:

<span style="color:rgb(51,51,51);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13.524px;font-weight:normal;line-height:20.286px;">dbid name segmap <span style="color:rgb(51,51,51);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13.524px;font-weight:normal;line-height:20.286px;">-- --- --- <span style="color:rgb(51,51,51);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13.524px;font-weight:normal;line-height:20.286px;">2 master 1 <span style="color:rgb(51,51,51);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13.524px;font-weight:normal;line-height:20.286px;">2 <span style="color:rgb(51,51,51);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13.524px;font-weight:normal;line-height:20.286px;">pubs2_data 7

Source : http://sybasehowto.blogspot.in/2011/04/ase-how-do-i-move-tempdb-off-of-master.html, https://scn.sap.com/thread/3383203