I am looking to find all oracle directories which exist in database. The database version is Oracle 10g.
The command select * from all_directories; returns only a couple of them. Can this be permission related?
Try running it asa user with DBA privileges.