View Files in Directories

--
-- To View a File Stored in an Oracle Directory in AWS RDS
--
-- On AWS RDS you do not have access to the server or to a proper SYSDBA account.  
-- As a result you are defendant on lots of AWS RDS packages.
-- Or in some instances, you need to find new ways of achieving the same thing
-- This shows how to view a Data Pump log.
--
 
SELECT text FROM TABLE(rdsadmin.rds_file_util.read_text_file('DATA_PUMP_DIR','&MyDataPumpLog'))
/

Published July 06, 2022

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License