Received the following error (ORA-39166: Object el_Viol??n was not found) when running the APPLY.sh script

Owned by Clive Otten (Unlicensed)
Jan 22, 2020

Problem Description

When running the APPLY.sh command, I received the following error:

ORA-39166: Object el_Viol??n was not found

Solution

This is often due to NLS_LANG settings and not really a Dbvisit issue. There are two possible solutions:

  1. Create table needs to be done in either SQL DEVELOPER (which handles UTF-8 great), or by changing export NLS_LANG=AMERICAN_AMERICA.UTF8 before logging into database

  2. Change console session to UTF-8