List directory contents (-ls DIRECTORY option)

[maxsatula]

List directory contents (-ls DIRECTORY option)

There is no simple SQL or PL/SQL code to list Oracle directory object contents. None of methods are perfect. Perhaps, ocp might detect which database objects are accessible to the logged user and use any of them.

Help wanted: please add other possible alternatives to the listed below

DBMS_BACKUP_RESTORE and X$KRBMSFT

http://www.morganslibrary.org/hci/hci002.html

• Needs EXECUTE privilege on DBMS_BACKUP_RESTORE
• Needs a view and/or synonym for X$KRBMSFT, since it is accessible for SYS only

Self made stored procedure written in Java

https://asktom.oracle.com/pls/asktom/f?p=100:11:0%3a%3a%3a%3aP11_QUESTION_ID:439619916584

• Needs to create an object (java procedure) in the database
• Requires special permissions to operate filesystem from java (dbms_java.grant_permission SYS:java.io.FilePermission)

Known Java framework

http://sourceforge.net/projects/oracle-jutils

• Requires something to be installed in the oracle database

External tables

http://www.oracle-developer.net/display.php?id=513

• Needs additional objects (external table) in the database
• Needs a script put on the database server
• Produces SQL Loader log files each time used (TODO: check this)

External Procedure in C

[maxsatula]

Reopening to keep searching for a better solution.