Error "ORA-01406: fetched column value was truncated" Creating Extract When Using Custom SQL

Published: 23 Jun 2014
Last Modified Date: 27 Feb 2017


When you are using custom SQL in your data source connection and you try to create an extract , the following error might occur:
Oracle database error 1406: ORA-01406: fetched column value was truncated
Unable to create extract

When connecting to the Oracle data base and creating an extract without custom SQL, the extract completes successfully.


  • Tableau Desktop
  • Oracle
  • Custom SQL


As a workaround, rather than using Custom SQL, use the same code to create a materialized view directly in the database. 
Did this article resolve the issue?