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

Issue

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.

Environment

Tableau Desktop 2022.1 - 2021.2 only

Resolution

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' />

<customizations>

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

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

</customizations>

</connection-customization>