Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Previous revision
knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora-00942 [2018/01/20 10:33]
knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora-00942 [2023/12/15 09:17] (current)
volha.zhyrava
Line 1: Line 1:
 +\\
 +[[https://​www.ispirer.com|Ispirer Website]]
 +[[https://​www.ispirer.com/​products/​oracle-migration|Ispirer Capabilitie:​ Oracle Migration]]
 +[[https://​www.ispirer.com/​download/​download-demo|Free Trial]]
 +====== ORA-00942: Table or View Does Not Exist ======
  
 +**Symptoms**
 +
 +After choosing Oracle ODBC connection on a "​Source Options"​ page and clicking "​Next"​ button, you may see the warning message:
 +
 +{{:​knowledge-base:​database-migration:​setup-and-troubleshooting:​oracle:​ora_00942.png?​nolink|}}
 +
 +**Cause**
 +
 +When we set an ODBC Connection on a "​Source Options"​ page, our tool executes predefined SQL queries to the system objects, using the specified connection, in order to extract information about the objects that were created in your source database. And when we see such error, it means that user, that we specify at this page, doesn'​t have enough privileges to read information from system objects.
 +
 +**Solution**
 +
 +You need to assign to the Oracle user appropriate privileges to read all the information from the system objects. So, the following privileges are required to support the export for Oracle objects:
 +  * CREATE SESSION
 +  * SELECT ANY TABLE
 +  * GRANT SELECT ON sys.procedure$
 +  * GRANT SELECT ON dba_users
 +  * GRANT SELECT ON dba_part_key_columns
 +  * GRANT SELECT ON dba_sysnonyms
 +  * GRANT ALL [PRIVILEGES] ON OWNER.OBJECT_NAME for each object that needs to be migrated
 +
 +More information on how to assign all the required privileges you can find here:
 +
 +**__[[knowledge-base/​database-migration/​setup-and-troubleshooting/​oracle/​source-user-privileges|Setting Up Source User Privileges]]__**
 +
 +\\
 +If you have any other questions, please contact us: [[[email protected]]]