How to read live logs from SQL?
Consider that you want to read the following application log from SQL.
/var/log/appDaily.log
1. Create a directory
CREATE OR REPLACE DIRECTORY live_Log_Directory AS '/var/log';
2. Create external table
CREATE TABLE Live_APP_Log(
log_text CHAR(250)
)
ORGANIZATION external(
Type Oracle_Loader
Default Directory live_Log_Directory
records delimited by newline
LOCATION('appDaily.log')
Reject limit unlimited;
3. Create a view on Live_APP_Log
Create or Replace view App_Log_Information
AS
Select * from Live_APP_Log;
4. Grant necessary permissions to users
5. Now Query Live_APP_Log whenever you want to fetch log information from SQL
Consider that you want to read the following application log from SQL.
/var/log/appDaily.log
1. Create a directory
CREATE OR REPLACE DIRECTORY live_Log_Directory AS '/var/log';
2. Create external table
CREATE TABLE Live_APP_Log(
log_text CHAR(250)
)
ORGANIZATION external(
Type Oracle_Loader
Default Directory live_Log_Directory
records delimited by newline
LOCATION('appDaily.log')
Reject limit unlimited;
3. Create a view on Live_APP_Log
Create or Replace view App_Log_Information
AS
Select * from Live_APP_Log;
4. Grant necessary permissions to users
5. Now Query Live_APP_Log whenever you want to fetch log information from SQL
Comments