ERROR: Teradata execute: No more room in database

[cellurl]

proc sql;
connect to teradata (MODE=TERADATA user=xxxxx password="xxxxx" tdpid='xxxxxxxxxxx' connection=global);
execute( 

insert into BLAH_DB.table 
select 
*
from blahdb.othertable cst inner join otherdb.tablec ch on cst.cust_acct_nbr = ch.cust_acct_nbr 

) by teradata;
ERROR: Teradata execute: No more room in database BLAH_DB.

[cellurl]

it is 31 million rows. If I put in "top 1", it works, so it is mad about the size.

Also, If I do it in Teradata SQL Assistant, it loads all 31 million rows with no problem.

Thanks for helping. I am stumped!
Jim

[cellurl · Accepted solution]

Solution:
The column names were not the same.

Somehow that makes it blowup (x-product??)