Properties |
Device Number | 9 |
Physical File Name | /dev/rdsk/c9t4d0s3 |
Is Default Device | No |
Is Physical Disk | Yes |
Is Logical Disk | No |
Is Mirrored | No |
Physical Mirror Name |
Size |
Device Size | 1000.00 MB | Space Used | 1000.00 MB | Space Free | 0.00 MB |
Database Fragments |
Database Name | Size | Database Usage |
icsa_tmp | 500 | data only |
udf | 100 | data only |
publications | 10 | data only |
speval | 390 | data only |
DDL |
USE master go DISK INIT NAME='data_dev5', PHYSNAME='/dev/rdsk/c9t4d0s3', VDEVNO=9, SIZE=512000, VSTART=0, CNTRLTYPE=0 go EXEC sp_diskdefault 'data_dev5',defaultoff go