In this post, we will learn about sql loader in oracle, SQL loader syntax in oracle, SQL loader direct path load, SQL loader examples SQL Loader in Oracle How Sql loader works Two types of input have to be provided to SQL*Loader. SQL Loader generates three files Sql loader Syntax Syntax sqlldr keyword=value Example SQLLDR […]
SQL loader in oracle Read More »
In this post, we will discuss password file in oracle,oracle password file utility orapwd, how to create a password file in oracle , create password file in RAC Introduction to ORAPWD How to create password file in oracle Creating a password file, via orapwd, enables remote users to connect with administrative privileges. Here is the
Oracle password file Utility :ORAPWD Read More »
As part of learning the Oracle SQL tutorial, Here is good detail on the Aggregate functions in oracle Aggregate functions in oracle/Group Functions Group Functions unlike single value functions operate on the set of rows and return one row per group. The set of rows may be a whole table or the table split into groups
Aggregate functions in oracle Read More »
In this post, we will be discussing opatch, How to check the opatch version or opatch version command, apply the patch(opatch apply), Upgrade, opatch lsinventory etc How to check the opatch version(opatch version command) we can check the opatch version using the below command Log in to the Oracle Database serverSource the Oracle Home$ORACLE_HOME/OPatch/opatch versionOracle
opatch version command, apply the patch, Upgrade,lsinventory Read More »
We sometime might see accounts getting locked in the Oracle Database. This may be because of failed login attempt due to the wrong password. So we often look at How to check failed login attempts in Oracle. Let’s discuss those below How to check failed login attempts in Oracle we can find the failed login
How to check failed login attempts in Oracle Read More »
We will discuss the difference between the Oracle database and Oracle instance in this post What is Oracle Database Oracle database is comprised of a set of operating system files containing data entered by users or applications and structural information about the database itself called database metadata. Information is stored persistently in these files. A
Oracle Database and Oracle Instance Read More »
