Hey guys, in this blog I am going to explain to you about Oracle Database User Creation. USER- User is basically used to connect to database. All Database objects like table, index, view etc. can be created under that user. In Oracle users and schemas are essentially the same thing. You can consider that a user…

Read More

Hey guys, in this blog I am going to explain to you about Import and Export in Oracle. Fig.1  On clota-labl08- Step 1- To Check the Process in Oracle like pmon.  [oracle@clota-labl08 ~]$ ps -ef | grep -i pmon oracle      2207       1  0 Sep26 ?        00:00:05 ora_pmon_clotaDB oracle     43671   37353  0 04:47 pts/4    00:00:00 grep –color=auto -i pmon Step 2 – To Set the Environment…

Read More

Hey guys, in this blog I am going to explain to you about Blocking Session in Oracle. Blocking Session- A blocking session in Oracle Database is one where one session is impeding the progress of another session. When one session has a lock on a resource that another session is attempting to access, this can…

Read More

Hey guys, in this blog I am going to explain to you about Oracle Connectivity and Networking. Oracle Connectivity and Networking- Oracle Connectivity and Networking in Oracle Database 19c refers to the set of features and technologies that enable communication between various Oracle Database system components, such as clients, servers, and other database-related elements. In…

Read More

Hey guys, in this blog I am going to explain to you about Oracle Tablespace. Oracle Tablespace: –  An Oracle database consists of one or more logical storage units called tablespaces, which collectively store all of the database’s data.  A table space is a storage structure; it contains tables, indexes, large objects, and long data.  Type of…

Read More

Hey guys, in this blog I am going to explain to you about Different types of objects in Oracle Database. Different Types of Objects in Oracle Database- Different kinds of objects are used to store and manage data in an Oracle database. These objects fulfil various functions and are arranged within the database to allow…

Read More

Hey guys, in this blog I am going to explain to you about SP File and Pfile in Oracle. Spfile: – It refers to Server Parameter file (spfile$ORACLE_SID.ora). Server parameter files are binary files that exist only on the server and are called from client locations to start up the database. Since spfile is a…

Read More

Hey guys, in this blog I am going to explain to you about Oracle objects. ORACLE PROCEDURE- A group of PL/SQL statements is called a procedure and what makes it unique is that it can be called by name. The call spec or the call specification is utilized to call a Java method or a…

Read More

Hi guys, in this blog I am going to explain you about Oracle Architecture. Oracle Architecture- The relational database management system (RDBMS) known as Oracle Database was developed and commercialized by Oracle Corporation. One of the most widely used RDBMSs available, it is used to store and retrieve data for a variety of purposes. The…

Read More

Hi guys, in this blog I am going to explain you about In-Depth Oracle Import and Export. Export In 0racle- In the context of databases, “export” refers to the process of extracting data from a database and saving it to an external file or another storage format. This process allows you to create a snapshot…

Read More

Hi guys, in this blog I am going to explain you about Indexes in Oracle. Indexes in Oracle- In Oracle Database 19c, as in previous versions, indexes play a crucial role in enhancing query performance by providing a faster access path to data. Here are some key aspects of indexes in Oracle 19c: B-Tree Indexes-…

Read More