If i run "sqlplus user/pass@connectstr" - works fine.
If i am user oracle and run "sqlplus user/pass" - works fine.
But if I am another user and run "sqlplus user/pass" - get error ERROR: ORA-03113: end-of-file on communication channel.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Subquery in Oracle:
Sub queries are one of advance queries in oracle.
Types of advance queries:
• Sub Queries
• Hierarchical Queries
• Set Operators
Sub queries are know as the query called from another query or another subquery. It can …
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…