Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to list all directories by system user ?

715772Aug 12 2009 — edited Aug 12 2009
Hi all,


last month I`ve create directory for export (data pump). The problem is that I didnt put it to the documentation. I would like to know how can I list all directories (granted and created in sqlplus) using simply sql statement.

Is there any command for this like SELECT * FROM ALL_USERS; ?



would be great if somebody can help me
This post has been answered by 189821 on Aug 12 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2009
Added on Aug 12 2009
6 comments
117,476 views