The Error: Of course the problem might always be due to actual wrong password or the lack of password file. However, in some strange circumstances…
FIND & DELETE Find and delete files with .aud extension in some path older than 14 days: When the number of files is huge, the…
You would most probably get the ORA-1804 error when you try to set time zone on a session like: Or you may get the ORA-1804…
First, let’s create our own audit log table to track the info about the host and time of the attempt: Then create the trigger: Now,…
Starting with the Oracle Database version 12.2, during the materialized view refresh, the below temporary tables are being created: This mechanism is implemented to address…
There might be many reasons to export the Oracle object statistics. For example, you may want to save the current statistics, that is to say,…
12_PDF_121SIOnOEL62OnASMDownload
11_PDF_112SIOnRHEL68OnASMDownload
10_PDF_112SIOnRHEL68Download
8_PDF_112SIOnOEL510onASMDownload