Oracle Error Creating an Extract "Error code:4078C414 [SQLSTATE:3F000] schema does not exist"

Published: 05 Apr 2023
Last Modified Date: 06 Apr 2023


When Tableau Desktop is connected to Oracle, some tables are unable to create as an extract.  The following error will display:
Error code: 4078C414, [SQLSTATE:3F000] schema "x" does not exist. Unable to create extract.
In the live connection the data preview is unavailable. 


  • Tableau Desktop 2022.1 - 2021.2 only


Option 1

Upgrade to Tableau Desktop 2021.3 or newer.  Product downloads are available on the Tableau Release website

Option 2

If not able to upgrade, addd an oracle.tdc file in the %userprofile%\Documents\My Tableau Repository\Datasources\ folder with the below content.  If not familiar with creating a TDC file, please review the process in the Tableau Online Help.
<?xml version='1.0' encoding='utf-8' ?>
<connection-customization class='oracle' enabled='true' version='10.0'>

    <vendor name='oracle' />

    <driver name='oracle' />


        <customization name='CAP_JDBC_METADATA_USE_RESULTSET_FOR_TABLE' value='yes' />

        <customization name='CAP_JDBC_METADATA_SUPPRESS_PREPARED_QUERY' value='yes' />




This issue is being investigated under Known Issue ID 1504010 for versions 2021.1 and 2021.2.

Additional Information

Under the same schema, some tables will not have this issue. 
Did this article resolve the issue?