Skip to Main Content
Forums

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!

Use PL/SQL to retrieve list of files in data pump directory

IfYouAreCallingMe_YouMustBeScrewedJun 16 2017 — edited Jun 16 2017

Hi all,

I've previously used an SQL command to retrieve the names of files stored in the DATA_PUMP_DIR directory, but I can no longer find it, or the resource that gave my the basics of it.

Which is massively annoying.

Has anyone used something similar?

Note: this command was not Java based or any other external software, it was a single line of SQL that gave me the info.

Thanks in advance
This post has been answered by JuanM on Jun 16 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2017
Added on Jun 16 2017
8 comments
1,884 views