Reading the Files in an Oracle Directory on AWS RDS

List the Files in an Oracle Directory on AWS RDS


--
-- List the Files in an Oracle Directory
--
-- 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
--
 
SELECT * FROM table(rdsadmin.rds_file_util.listdir('BDUMP')) order by mtime
/

Reading the File in an Oracle Directory on AWS RDS


--
-- Reading the File in an Oracle Directory on 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
--
 
SELECT text FROM table(rdsadmin.rds_file_util.read_text_file('BDUMP','MyFile'))
/

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