Good morning, Glen.

select * from dba_directories;

Whew! Thanks for the easy one. :-)

Cheers,

Jeff

-----Original Message-----
From: Glen
[mailto:oracledba-ezmlmshield-x20912971.[Email address protected]
Sent: Monday, March 31, 2008 11:17 AM
To: LazyDBA Discussion
Subject: external tables -> find "directory"

What is the sql to find the names of the directory and their
corresponding OS paths.







Glen Bernas | Oracle Database Administrator | SunGard | Phase3 | 3 Van
de Graaf Drive Burlington, MA 01803

Tel 781.999.9021 | Mobile 339.223.7946 | Fax 781.275.7411 |
www.sungard.com/phase3 <http://www.sungard.com/phase3>

P Think before you print

CONFIDENTIALITY: This email (including any attachments) may contain
confidential, proprietary and privileged information, and unauthorized
disclosure or use is prohibited. If you received this email in error,
please notify the sender and delete this email from your system. Thank
you.





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Note: This message, including attachments, is from H&R Block Financial Advisors,
Inc., Member NYSE, SIPC. This is not a solicitation of any order to buy or sell. The
information contained herein is deemed to be reliable but is in no way warranted by us as
to accuracy or completeness. Messages are monitored and retained by the Company, but
the company cannot guarantee the security of this message. The company, and its
associates, may not accept orders to affect purchase or sale transactions, accept funds,
securities, or similar instructions via email. If you are not the intended recipient of this
message promptly delete this message and notify the sender of the delivery error by
return email or calling 1.800.HRBLOCK and selecting the option for 'Financial Services'
You may not forward, print, copy, distribute, or use the information in this message if
you are not the intended recipient.

Oracle LazyDBA home page