Oracle

Indexes are used to access data in the table faster.  A book is like a table of contents. When searching for a topic in the book, we can quickly find …

Hi, I will explain Cross Platform Oracle Database Migration Using Transportable Tablespace ( XTTS ) With Zero Downtime in this article.

DBMS_RLS Package We use DBMS_RLS to create, modify, or delete security policies with VPD.  The DBMS_RLS.ADD_POLICY procedure allows us to create a VPD security policy. The definition of parameters used in …

Virtual Private Database allows us to define constraints on tables and views based on row and column security policies. It should not be considered as a separate database because of the …

Application Context are memory fields that contain information about the sessions of users connected to the database.  According to the information in the application context, the logged-on user is denied or …

Spfile The parameter file that it used to configure the instance when the database was opened. When the database is created, the spfile <ORACLE_SID> .ora file is created under the …

When the database is first created, there are some basic parameters that are most necessary. We can see these parameters with the following query, SQL> select name from v$parameter where …

Hello everyone, in this tutorial we gonna examine PasswordFile – orapwd utility in Oracle. The password file is an optional file. It’s use has some advantages.

Hi everyone, Today i will show you how to connect SQL Developer Web. Oracle SQL Developer allows database users and administrators to do their database tasks in fewer clicks and …

Hi everyone, Today i try to explain Oracle Database 12c In-Memory. In-Memory is a very important subject for Database and DWH. Oracle DB to store data in row format at …