How to unregister materialized view from source DB
If a remote MV is no longer available or if you move to a new server because of data migration, version upgrade etc. and somehow don’t need the […]
More DetailsHow to get the contents of unknown SYS REFCURSOR
You can use the following procedure in order to get the unknown number of columns and column types.
More DetailsWe have been awarded Top 100 Oracle Blog
Hello All, we have been awarded Top 100 Oracle Blog by feedspot. I really would like to thank to feedspot team. There are very valuable blog writters in […]
More DetailsHow to use Flashback
Flashback feature is available only for enterprise edition. In this article, Oracle 19c has been used for all examples. With flashback feature you can recover your table or […]
More DetailsHow to open pluggable database automatically
There are different startup phases of Oracle database. In multitenant architecture, startup and shutdown commands of container database are same as the regular database. After opening the container […]
More DetailsHow to create a temporary job
Basically, you can create a single scheduler job by the following syntax. This job executes and drops itself automatically. If your procedure that used in the scheduler job […]
More DetailsHow to use Data Pump between different Oracle versions
According to the documentations, if the target database is higher than the source database, the VERSION parameter does not have to be specified. There is an exception, if […]
More DetailsHow to export / import schema with Data Pump
There are several export/import modes. These are listed in the following section. Full Mode Schema Mode Table Mode Tablespace Mode Transportable Tablespace Mode In this article I will discuss about schema mode export […]
More DetailsORA-30926 unable to get a stable set of rows in the source tables
In this post, I am going to talk about ORA-30926 error and how to solve it. Let’s create the following tables for our example. This error occurs due […]
More DetailsHow to split comma separated string into rows
In rare cases we might need to convert string data into rows. So, you can simply do this using the code below. If your string is not comma […]
More Details