Re: Test Directory Object Using SQLPlus

Michael42 wrote:
> Hello,
>
> Could someone please recommend some SQL to test if a Directory Object
> is working?
>
> I have been using EM's (dbconsole) test option but would like to be
> able to do this from SQLPlus.
>
>
> Thanks very much,
>
> Michael

The only test of a directory object is to try to use it.

Try using it to build an external table. For example, modify the demos here: http://www.psoug.org/reference/externaltab.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org