ORA-65140: invalid common profile name

How to solve if you get an error “ORA-65140” while creating a profile on Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 . Let us see how we can resolve this error. Error: Now alter the system session “_oracle_script” to true. Now let us try to run the profile again. We can also create the profiles […]
Read More »

ORA-01950: no privileges on tablespace

Many times we might encounter with an error on our application log or from database alert lot for ORA-01950 error. Which means that the user/schema user trying to perform a job where it required to extent the tablespace that is tied with the user or the objects, the error occurs because it doesn’t have the […]
Read More »

ORA-04068: existing state of packages has been discarded

In this blog, we will see how to solve ORA-04068 with an example while using global variables. Create a sample table: Let us also try to insert a row to the table to verify if it works: Now let us try to login with another session and try to modify the package and add a […]
Read More »

ORA-01950: no privileges on tablespace ‘USERS’

In this blog let us we will see how to solve ORA-01950. This error occurs if a user doesn’t have the quota to the right tablespace, in my case my user doesn’t have the access to “USERS” Tablespace. To fix this issue we can grant the unlimited quote to the user or grant-specific size of […]
Read More »

Setting up IDEL_TIME on Oracle Database

In this blog we will see how we can setup the IDEL_TIME parameter on Oracle database. Why we need to set IDLE_TIME ? When we need to control the inactive time for any sessions in Oracle, we need to define the time in minutes. Before making any changes to the parameter you need to verify […]
Read More »

Dynamic Version Controlling of Oracle Metadata using shell script

In this blog, we will see how we can automate the process of moving Oracle metadata to version control system, in my case I am using GIT using a simple shell script to avoid manual intervention. The general process of code movement to Higher environments During any development process for any organization, the critical part […]
Read More »

Converting BYTES to CHAR on Oracle database

In this blog, I will be sharing the issues that we faced while converting the data type and NLS semantic to CHAR from BYTES. This was one of the business use cases where we needed to convert the entire columns throughout the schema from BYTES to CHAR types only for VARCHAR2 columns datatypes. Sometimes we […]
Read More »

Checking size of the tablespaces in Oracle for one schema

Most of the time we try to verify what objects are mapped to what tablespace. But most of the time we try to verify the size of the current schema. Imagine there could be a situation where you have a schema and all of its objects are been scattered around multiple tablespaces. While might not […]
Read More »

Using FIRST_VALUE & LAST_VALUE in Oracle Analytic Functions

In this blog, we will see how to use FIRST_VALUE & LAST_VALUE in Oracle with simple examples. FIRST_VALUE and LAST_VALUE in Oracle These are Oracle analytical functions used to return the first value or the last value from a set of ordered rows. These functions can get the first value or the last value within a […]
Read More »

Creating a JAVA Stored procedure on Oracle

In this blog, we will see how we can create a simple JAVA class on Oracle and calling the class using a simple function. Without taking more time, let us create one user on the Oracle database and then define a JAVA class and associate it with one Oracle function. Create one user to test […]
Read More »