How 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 DetailsFlashback 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 DetailsThere 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 DetailsBasically, 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 DetailsAccording 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 DetailsThere 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 DetailsIn 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 DetailsIn 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 DetailsAdaptive cursor sharing has been used in Oracle 11g first. This feature enables a single statement that contains bind variables to use multiple execution plans. According to the […]
More DetailsAnalytic functions have been used from the early versions of Oracle. It make it easy to developers in many tasks, especially reporting. In this article, I am going […]
More DetailsYou can find the lock accounts from the following query. So, in order to unlock the admin user. Login with SYS and execute the following PL/SQL block. You […]
More Details