All Forums Database
juanalfonso 41 posts Joined 01/16
26 Aug 2016
Teradata: No more room in journal table for novaquality.journals

Hello,

 

When I tried to insert more than a million of rows in a table, I got the following error:

  • No more room in journal table for novaquality.journals

I have a Teradata Express 15.10. About the space I have in the "novaquality" database:

  • Perm Space:10.000.000
  • Spool Space: 39.604.322.304
  • Temp Space: 39.604.322.304

I don't know how to extend the journal table. What do I have to do to solve it?

 

Thanks and regards

Fred 1096 posts Joined 08/04
26 Aug 2016

In Teradata Studio, use the "Move Space" tool in the Teradata Administrator perspective.

ToddAWalter 316 posts Joined 10/11
26 Aug 2016

A SHOW table on the target table will showthe database location for the journals. It is possible the journals are in a different database that is out of space even if the database containing the table has plenty of space.

juanalfonso 41 posts Joined 01/16
30 Aug 2016

Ok, Thanks!

You must sign in to leave a comment.