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 …
How to enter special characters like "&" in oracle database?
Aug 29, 2016 · INSERT INTO STUDENT(name, class_id) VALUES ('Samantha', 'Java_22 & Oracle_14'); If I try to run this query I am getting a popup and it asks me to enter value for Oracle_14. …
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 sessions and …
oracle database - ORA-28001: The password has expired - Stack Overflow
I had same problem, i am trying to login database it appear a message with: "ORA-28001: The password has expired" , I have fixed the problem simple steps 1.open command prompt 2.type …
How do I resolve this "ORA-01109: database not open" error?
May 3, 2017 · 2 Open SQLPLUS and login with sys as sysdba. After that run alter pluggable database <<database_name>> open; This Worked for me .
Checking oracle sid and database name - Stack Overflow
Checking oracle sid and database name Asked 14 years, 6 months ago Modified 4 years, 1 month ago Viewed 912k times
oracle database - Find out the history of SQL queries - Stack Overflow
Oct 18, 2018 · 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 …
sql - How do we check version of Oracle - Stack Overflow
Oct 1, 2014 · How do we check version of Oracle on which we are working? How do we check the version of the interface on which we are working? I have tried select v$ from version ;
Find Size of a Database in Oracle - Stack Overflow
Nov 29, 2010 · Find Size of a Database in Oracle Asked 15 years ago Modified 6 years, 1 month ago Viewed 114k times
How to find Oracle Service Name - Stack Overflow
Dec 2, 2016 · I have an Oracle database on my network which I am able to connect to with Oracle SQL Developer, using hostname, port, username, password and the SID. I need to connect another …