How to view alert log file
First of all, in order to find your log files location in the operating system where the database is located, you can query to V$DIAG_INFO view. It contains […]
More DetailsFirst of all, in order to find your log files location in the operating system where the database is located, you can query to V$DIAG_INFO view. It contains […]
More DetailsHow to find the difference between two dates If you want to find the difference between two dates according to different time types, you can use the EXTRACT […]
More DetailsIf 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 DetailsYou can use the following procedure in order to get the unknown number of columns and column types.
More DetailsHello All, we have been awarded Top 100 Oracle Blog by feedspot. I really would like to thank to feedspot team. There are many valuable blog writters in […]
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 Details