Oracle

Hi I wanted share one useful script which I wrote few minutes ago ( part of my big project )  🙂 You know we do Oracle Restore and we need …

I will explain how to Manual Upgrade Oracle Database From 11.2.0.4 to 12.2.0.1 without DBUA in this article. Let’s review the Oracle 12c Upgrade | Manual Upgrade Oracle Database.

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.