Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008
    Posts
    22

    Unanswered: How to increase size of data_seg in Sybase

    Hi,

    In my database calculation.it show following things
    segment_name total_space free_space
    system XXXX.00 MB XXXX.00 MB
    default XXXX.00 MB XXXX.00 MB
    logsegment XXXX.00 MB XXXX.00 MB
    data_seg 00.00 MB 00.00 MB
    index_seg 00.00 MB 00.00 MB

    How to increase the size of data_seg?

    Regards
    RS

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Code:
     System Procedure                                                               
     sp_addsegment - Defines a segment on a database device in a database.          
       sp_addsegment segname, dbname, devname                                       
                                                                                    
     sp_dropsegment - Drops a segment from a database or unmaps a segment from a    
             particular database device.                                            
       sp_dropsegment segname, dbname [, device]                                    
                                                                                    
     sp_extendsegment - Extends the range of a segment to another database device.  
       sp_extendsegment segname, dbname, devname                                    
                                                                                    
     sp_helpsegment - Reports information about a particular segment or about all   
             segments in the current database.                                      
       sp_helpsegment [segname]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •