All Forums Database
jsergey 15 posts Joined 06/07
02 Aug 2007
Error: No more room in database DBC

Hello.I have some already created databases and want to add some table into them. But when I trying to create new tables teradata gives out to me message "No more room in database DBC".What does it mean and how can I fix this problem ?I can create new tables only when some other tables will be dropped. But no one table can be dropped.Thanks.

joedsilva 505 posts Joined 07/05
02 Aug 2007

Most likely that's because you allocated all the perm space to other databases ...check what's the free perm in DBC, and if it's very low, move some space from other databases...

BBR2 96 posts Joined 12/04
02 Aug 2007

I also believe that some of the tables have pretty bad indexes.You may want to account for this skewness when you move space.Thanks,Vinay Bagare

Jim Chapman 449 posts Joined 09/04
02 Aug 2007

I assume you are creating tables in a user database, not in DBC. Database DBC contains only system tables. If it has no more room, it could be because either (a) not enough space is allocated to the DBC database, or (b) some system table is using too much space. A possible culprit is the transient journal. Especially in V2R6.2 and later, the journal uses a lot of space (due to write-ahead logging). Space should be recovered automatically as transactions commit, but a long-running transaction can cause space not to be released quickly enough.The DBC.DiskSpace and TableSize views should help you pinpoint the problem.

leo.issac 184 posts Joined 07/06
02 Aug 2007

Try deleting some rows in Accesslog and DBQL tables in dbc.You might free some space there.Check to see the growth of your Accesslog and Query log tables. If they are growing indefinitely and filling up the space, then probably you might have anabled the logging option on maximum number of database objects. plan your logging options accordingly.

You must sign in to leave a comment.