Querying the Alert Log using External Tables

Run this PL/SQL block as SYS. This will create the Directory, grant the required privileges on the Directory and then create the External Table in the SYSTEM schema. DECLARE BDumploc VARCHAR2(200); ORASID VARCHAR2(16); ObjectExists EXCEPTION; PRAGMA EXCEPTION_INIT(ObjectExists,-955); BEGIN SELECT value INTO BDumploc FROM v$parameter WHERE name=’background_dump_dest’; — create the directory for the bdump dir EXECUTE […]

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?