Teradata: No more room in journal table for novaquality.journals

Database
Enthusiast

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

Juan
Tags (1)
3 REPLIES
Teradata Employee

Re: Teradata: No more room in journal table for novaquality.journals

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

Teradata Employee

Re: Teradata: No more room in journal table for novaquality.journals

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.

Enthusiast

Re: Teradata: No more room in journal table for novaquality.journals

Ok, Thanks!

Juan