Skip to Main Content
Forums

Oracle Database Discussions

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 file names in database directories using SQL commands ?

johnpau2013Nov 13 2014 — edited Nov 13 2014

We have oracle 11g R2 ( 11.2.0.4.0)

There is a default database directory created  DATA_PUMP_DIR   ( /oradata/datapump) .

There are some files  ( .DMP and .LOG) in the above directory.

1) How to list the file names in the database directory using oracle SQL command ?

2) If there is a .LOG file in the above directory, is there a way to read contents of the .LOG file using Oracle SQL command ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 11 2014
Added on Nov 13 2014
#general-database-discussions
7 comments
3,464 views