Grant Create Index to User?
CREATE INDEX Privilege? Tried to grant a CREATE INDEX system privilege to an user, it failed with ORA-00990. SQL> grant create index to oe; grant… Read More »Grant Create Index to User?
ORA-00942
For globalization support, here I listed its messages in difference languages.
| NLS_LANGUAGE | Error Message |
|---|---|
| ALBANIAN | ORA-00942: table or view does not exist |
| AMERICAN | ORA-00942: table or view does not exist |
| ARABIC | ORA-00942: الجدول أو الجدول الاعتباري غير موجود |
| ASSAMESE | ORA-00942: table or view does not exist |
| AZERBAIJANI | ORA-00942: table or view does not exist |
| BANGLA | ORA-00942: table or view does not exist |
| BELARUSIAN | ORA-00942: table or view does not exist |
| BRAZILIAN PORTUGUESE | ORA-00942: a tabela ou view não existe |
| BULGARIAN | ORA-00942: table or view does not exist |
| CANADIAN FRENCH | ORA-00942: Table ou vue inexistante |
| CATALAN | ORA-00942: la taula o la vista no existeixen |
| CROATIAN | ORA-00942: table or view does not exist |
| CYRILLIC KAZAKH | ORA-00942: table or view does not exist |
| CYRILLIC SERBIAN | ORA-00942: table or view does not exist |
| CYRILLIC UZBEK | ORA-00942: table or view does not exist |
| CZECH | ORA-00942: tabulka nebo pohled neexistuje |
| DANISH | ORA-00942: tabel eller view findes ikke |
| DUTCH | ORA-00942: Tabel of view bestaat niet. |
| EGYPTIAN | ORA-00942: الجدول أو الجدول الاعتباري غير موجود |
| ENGLISH | ORA-00942: table or view does not exist |
| ESTONIAN | ORA-00942: table or view does not exist |
| FINNISH | ORA-00942: taulua tai näkymää ei ole olemassa |
| FRENCH | ORA-00942: Table ou vue inexistante |
| GERMAN | ORA-00942: Tabelle oder View nicht vorhanden |
| GERMAN DIN | ORA-00942: Tabelle oder View nicht vorhanden |
| GREEK | ORA-00942: πίνακας ή όψη δεν υπάρχει |
| GUJARATI | ORA-00942: table or view does not exist |
| HEBREW | ORA-00942: טבלה או view אינם קיימים |
| HINDI | ORA-00942: table or view does not exist |
| HUNGARIAN | ORA-00942: a tábla vagy a nézet nem létezik |
| ICELANDIC | ORA-00942: table or view does not exist |
| INDONESIAN | ORA-00942: table or view does not exist |
| IRISH | ORA-00942: table or view does not exist |
| ITALIAN | ORA-00942: tabella o vista inesistente |
| JAPANESE | ORA-00942: 表またはビューが存在しません。 |
| KANNADA | ORA-00942: table or view does not exist |
| KOREAN | ORA-00942: 테이블 또는 뷰가 존재하지 않습니다 |
| LATIN AMERICAN SPANISH | ORA-00942: la tabla o vista no existe |
| LATIN SERBIAN | ORA-00942: table or view does not exist |
| LATIN UZBEK | ORA-00942: table or view does not exist |
| LATVIAN | ORA-00942: table or view does not exist |
| LITHUANIAN | ORA-00942: table or view does not exist |
| MACEDONIAN | ORA-00942: table or view does not exist |
| MALAY | ORA-00942: table or view does not exist |
| MALAYALAM | ORA-00942: table or view does not exist |
| MARATHI | ORA-00942: table or view does not exist |
| MEXICAN SPANISH | ORA-00942: la tabla o vista no existe |
| NORWEGIAN | ORA-00942: tabellen eller utsnittet finnes ikke |
| ORIYA | ORA-00942: table or view does not exist |
| POLISH | ORA-00942: tabela lub perspektywa nie istnieje |
| PORTUGUESE | ORA-00942: tabela ou visualização não existe |
| PUNJABI | ORA-00942: table or view does not exist |
| ROMANIAN | ORA-00942: tabelul sau vizualizarea nu există |
| RUSSIAN | ORA-00942: таблица или представление пользователя не существует |
| SIMPLIFIED CHINESE | ORA-00942: 表或视图不存在 |
| SLOVAK | ORA-00942: tabuľka alebo pohľad neexistuje |
| SLOVENIAN | ORA-00942: table or view does not exist |
| SPANISH | ORA-00942: la tabla o vista no existe |
| SWEDISH | ORA-00942: tabell eller vy finns inte |
| TAMIL | ORA-00942: table or view does not exist |
| TELUGU | ORA-00942: table or view does not exist |
| THAI | ORA-00942: ไม่มีตารางหรือวิว |
| TRADITIONAL CHINESE | ORA-00942: 表格或視觀表不存在 |
| TURKISH | ORA-00942: tablo veya görüntü mevcut degil |
| UKRAINIAN | ORA-00942: table or view does not exist |
| VIETNAMESE | ORA-00942: table or view does not exist |
How to Resolve ORA-04063: view has errors
ORA-04063 ORA-04063 means the view that you want to grant to someone else has compile error, so the database cannot grant it to other users.… Read More »How to Resolve ORA-04063: view has errors
How to Resolve ORA-00955: name is already used by an existing object
ORA-00955 ORA-00955 means that the name of the schema object that you tried to create is already used and taken by some other existing schema… Read More »How to Resolve ORA-00955: name is already used by an existing object
How to Resolve ORA-00903: invalid table name
ORA-00903 In this post, I will introduce 3 main error patterns about ORA-00903, they are: Create Table Select Table Insert, Update and Delete Table Alter… Read More »How to Resolve ORA-00903: invalid table name
How to Resolve ORA-00942: table or view does not exist
ORA-00942 ORA-00942 means that SQL engine found no table or view in your usable scope. In other words, table or view does not exist. The… Read More »How to Resolve ORA-00942: table or view does not exist
How to List All Tables in Oracle
In this post, we will talk about three different views that can make Oracle show tables within defined scope, they are: Tables that You Own… Read More »How to List All Tables in Oracle
How to Resolve OGG-00519 Error Message
OGG-00519 In the remote database, you may not create all objects to resolve dependency problems. Here are some OGG-00519 DDL errors in REPLICAT report below:… Read More »How to Resolve OGG-00519 Error Message
How to Resolve OGG-00519 with ORA-00942
Recently, I initialized a set of EXTRACT / PUMP / REPLICAT for one schema, but some days after, the REPLICAT abended with this error: 2017-05-10… Read More »How to Resolve OGG-00519 with ORA-00942
How to Resolve ORA-12034: materialized view log on younger than last refresh
ORA-12034 Found an error ORA-12034 in alert log: ORA-12034: materialized view log on younger than last refresh Rationale ORA-12034 means that your last refresh older… Read More »How to Resolve ORA-12034: materialized view log on younger than last refresh
How to Check if Table is Granted to You
Is Table Granted? Sometimes, you may be not sure that if tables owned by others have ever been granted to you. Actually, there are several… Read More »How to Check if Table is Granted to You