No more room in database All.

Connectivity
Enthusiast

No more room in database All.

Hi,

I once created a DB which I filled with 5000 images (50MB each). Unfortunately I dropped the table lately so I am trying to recreate the table. But

after a few hundred entries the following message appears:

com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 14.00.00.13] [Error 2644] [SQLState HY000] No more room in database All.

I don't know why the database "All" is mentioned. I never created it and I don't refer to it in my code.

Displaying the perm space of this database shows that it is 0.0.

What does this DB has to do with filling my images into another DB?

1 REPLY
Teradata Employee

Re: No more room in database All.

When working with LOBs, the Teradata Database can return a misleading Database Error 2644 "No more room in database All."

This may indicate that your Teradata Database userid doesn't have enough perm space. You should try increasing the perm space for your userid.