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