oracle database - SQL Error: ORA-00942 table or view does not …
Aug 1, 2020 · 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 …
oracle database - Find out the history of SQL queries - Stack …
Oct 18, 2018 · Get list of queries to oracle database. 0. Oracle Table Queried or Modified Date. 0.
oracle database - Getting ORA-01031: insufficient privileges while ...
May 18, 2015 · If you are having trouble starting up Oracle, you may need to add the Oracle user to the dba group. For ORA-00942: table or view does not exist. You tried to execute a SQL …
How to check Oracle database for long running queries
Mar 8, 2009 · Multiple Oracle long running session created for single sqlID Transaction in Jboss7.1.1EAP and Oracle 11g 0 Java update 100 records taking long time after certain time
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 …
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 …
Find the server name for an Oracle database - Stack Overflow
Jan 24, 2015 · The query below demonstrates use of the package and some of the information you can get. select sys_context ( 'USERENV', 'DB_NAME' ) db_name, sys_context ( …
oracle database - ORA-28001: The password has expired - Stack …
Jan 16, 2018 · 1.open command prompt 2.type sqlplus 3.It will ask Enter Password, you can give old password, it will show password has expired ORA-28001 4.It will ask new password and …
Oracle: How to find out if there is a transaction pending?
Aug 19, 2009 · @CarloSirna Yes there are cases where Oracle will start a transaction even if you don't alter data. Connecting to a remote database is an example (see for example this thread …
Oracle: how to set user password unexpire? - Stack Overflow
Nov 20, 2009 · If you cause a database user's password to expire with PASSWORD EXPIRE, then the user (or the DBA) must change the password before attempting to log in to the …