oracle database - ORA-12154: TNS:could not resolve the connect ...
Oct 11, 2012 · 0 I had an issue at work. 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 …
oracle database - SQL Error: ORA-00942 table or view does not …
2 I am using Oracle Database and i had same problem. Eventually i found ORACLE DB is converting all the metadata (table/sp/view/trigger) in upper case. And i was trying how i wrote …
How to check the maximum number of allowed connections to an …
Oct 2, 2008 · What's the best way, using SQL, to check the maximum number of connections that is allowed for an Oracle database? In the end, I would like to show the current number of …
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 …
Search All Fields In All Tables For A Specific Value (Oracle)
Oct 16, 2008 · Is it possible to search every field of every table for a particular value in Oracle? There are hundreds of tables with thousands of rows in some tables so I know this could take …
Checking oracle sid and database name - Stack Overflow
Checking oracle sid and database name Asked 14 years, 4 months ago Modified 4 years ago Viewed 910k times
Connecting to Oracle Database through C#? - Stack Overflow
Sep 24, 2012 · I need to connect to a Oracle DB (external) through Visual Studio 2010. But I dont want to install Oracle on my machine. In my project I referenced: System.Data.OracleClient. …
How to list all the roles existing in Oracle database?
How to list all the roles existing in Oracle database? Asked 11 years, 10 months ago Modified 6 years, 10 months ago Viewed 281k times
How to generate an entity-relationship (ER) diagram using Oracle …
Jul 5, 2011 · I want to use Oracle SQL Developer to generate an ER diagram for my DB tables but I am new to Oracle and this tool. What is the process for creating an ER diagram in SQL …
database - How do I do a manual uninstall of Oracle ... - Stack …
Sep 17, 2008 · Sometimes my Oracle database on Windows gets hosed. How do I do a manual uninstall of Oracle?