Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In this article I will share an example about data pump usage. First we start with export. EXPORT: [crayon-6629da609d89b369704033/] [crayon-6629da609d8a5949140128/] or [crayon-6629da609d8a8515701460/] or [crayon-6629da609d8aa591820784/] …
Read More »ORACLE
Handling Oracle Audit Vault Services
In this article I’ll tell you how to stop Oracle Audit Vault Services. You should follow below sequence of steps: [crayon-6629da609e284868174715/] [crayon-6629da609e28b302331836/] [crayon-6629da609e28d612673433/] [crayon-6629da609e28e091203179/] …
Read More »New Audit Mechanism on Oracle 12c : Unified Auditing
Hello everyone, Today I want to talk about new auditing features on Oracle 12c. As you know in Oracle 11g and below versions there …
Read More »How To Log More Detailed Information in Oracle Listener Trace?
If the connection breaks and timeouts occurs due to network problems and you cannot convince your network team, you can monitor events between client …
Read More »Upgrade Oracle Opatch Version
OPatch consists of patching utilities that help ensure your Oracle software stays current and secure. Oracle recommends that you use the latest released OPatch, …
Read More »How To Fetch Explain Plan
Displaying an execution plan is made easy if you use the DBMS_XPLAN package. This packages provides several PL/SQL procedures to display the plan from …
Read More »How to Unlock an Expired Oracle User Whose Password is Unknown
In my previous article, I mentioned how to solve Oracle Password Expired Error (ORA-28001). In some cases, we must unlock user with the existing …
Read More »Oracle Password Expired Error
In this article, I will show you how to change users’ password expire policy. By default, all created users in Oracle Database will be expired …
Read More »Update Table Without Update Permission On 11gr2
I’m going to talk about a problem I tested in 11gr2 versions. Each user with a select permission in a table can update that …
Read More »How To Connect To Oracle On Linux and Solution Of The Error:” error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory”
In this article, I will share the necessary steps to connect to Oracle through the linux operating system and the solutions to the problems …
Read More »