No room available in the database if I upload data using mload

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Enthusiast

No room available in the database if I upload data using mload

Hi Experts,

I have been facing "no room available issue in database" with one table when I upload the data using mload script.


Same is working fine if I use data import wizard of Teradata studio.

Can anyone help me out why mload is raising this issue however same is working fine wizard.
Thanks for your support in advance.

Regards,
Anuj
2 REPLIES
Highlighted
Junior Contributor

Re: No room available in the database if I upload data using mload

Studio either uses FastLoad protocol or direct Inserts, but MLoad populates intermediate Work Tables in your target database.

 

EIther qualify the WT database in your MLoad script or switch to FastLoad (for an empty target table) 

 

Enthusiast

Re: No room available in the database if I upload data using mload

Hi Dnoeth,

 

Thanks for your prompt response.

 

Next day, same script is working fine without any modifications.

 

Was it a server issue? Can you help me to identify this issue.

 

Regards,

Anuj Kumar