Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 16 Nov 2005 @ 12:11:05 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   2644:NO MORE ROOM IN DATA BASE
 
From:   Anomy.Anom

Hi Friends,

I got an error 2644:NO MORE ROOM IN DATA BASE when I am loading data into one of the tables. From Teradata docs I got to know that Data base ran out of space and I need to either drop some tables or increase perm space of Database.

I have a user from which 4 databases got inherited.

             U
             |
     --------------------------
     |        |       |       |
     D        D       D       D

How should I increase permspace of the database ??? Should I modify perm space of user and then increase permspace or should I decrease permspace of other databases???

Also please tell me how would I know that Database space is filled from Database Info ??? ( In Teradata Administrator when I do show db info it shows permspace,spoolspace and temp space)

Please help out in this.

Thanks and Regards



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016