R
R
Romanchitoz2018-12-10 00:26:44
Oracle
Romanchitoz, 2018-12-10 00:26:44

Problem connecting Oracle database in IDEA?

Faced such a problem, created a database, created a table and data in it.
Connected to IDEA, in the DATASOURCE section through the database user, my newly created table is displayed in the list of tables, but when I want to view its data, an error occurs [42000][942] ORA-00942: table or view does not exist.
While in sqldeveloper , all data is visible. What could be the problem?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vapaamies, 2018-12-11
@vapaamies

  • Connection not under that user.
  • Quoted names are case sensitive. By default, table names are written without special characters and are case insensitive.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question