oracle database - SQL Error: ORA-00942 table or view does not exist ...
insert into user1.customer (name,surname) values ('michael','jackson'); The result will be "ORA-00942: table or view does not exist" even though user2 does have insert and select privileges on …
oracle database - ORA-12154: TNS:could not resolve the connect ...
Oct 11, 2012 · The oracle server was "patched" and one of the databases I use could not be connect via the TNSNames entry but via Basic connection. The Database was up and admin could see it was up …
oracle database - Find out the history of SQL queries - Stack Overflow
Feb 12, 2013 · An update SQL query was executed on the server, which caused many problems later. How can I get the list of update queries executed in last 2 months, so that I can trace the exact …
oracle database - How to download and setup SQLPlus for running …
This installation is for oracle 11g express edition. This is the link from which you can download oracle database software. extract the zip file (don't change the name) Start the "Setup" when asked to …
Newest 'oracle-database' Questions - Stack Overflow
4 days ago · Oracle CTE query not joining as expected (null fields when both tables joined) [closed] Enclosed is a query below that aggregates all lines from notes fields into one line, performs some …
How to get SID, Service Name and Port for Oracle database?
Jun 8, 2018 · I have oracle database running on address xx.xx.xx.xx I know login, password and initial catalog I am trying to set up new connection in Oracle SQL Developer so I can access this database …
Checking oracle sid and database name - Stack Overflow
Checking oracle sid and database name Asked 14 years, 7 months ago Modified 4 years, 2 months ago Viewed 912k times
oracle database - ORA-12170: TNS:Connect timeout occurred - Stack …
May 31, 2014 · I was trying to connect to the database here in my laptop using Oracle Toad but I kept on having this error: ORA-12170: TNS:Connect timeout occurred What are the possible reasons why I …
How to enter special characters like "&" in oracle database?
Aug 29, 2016 · If I try to run this query I am getting a popup and it asks me to enter value for Oracle_14. How can I enter special characters like & in the insert statement for oracle db?
How to check Oracle database for long running queries
Mar 7, 2009 · My application, which uses an Oracle database, is going slow or appears to have stopped completely. How can find out which queries are most expensive, so I can investigate further?