MOTF Troubleshooting #3 |Teradata MOTF - 3. Customer Reports Missing MOTF Table; OTF Table Present in Datalake - Teradata Vantage

Teradata® Open Table Format for Apache Iceberg and Delta Lake User Guide

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Teradata Vantage
Release Number
20.00
Published
October 2025
ft:locale
en-US
ft:lastEdition
2025-10-25
dita:mapPath
qrj1749167830193.ditamap
dita:ditavalPath
lli1749584660955.ditaval
dita:id
bsr1702324250454

Issue: The MOTF table is missing from the customer's system, but the corresponding OTF table exists in the Datalake.

Cause: The MOTF table was dropped, but the corresponding OTF table was not removed.

Resolution: Customer must use the diagnostic FORCEMOTFDROP at the request level to forcefully drop the OTF table(3.dot).

Diagnostic FORCEMOTFDROP on for request; Drop Table <Datalake_Name>.<OTF_DBName>.<OTF_Table_Name>;