DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Dbms_lob.filegetname

  1. #1
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94

    Dbms_lob.filegetname

    HI,
    How can I find out the physical name of the directory when the dir_name of:

    DBMS_LOB.FILEGETNAME(file_loc, dir_name, file_name);

    returns the logical named of the directory defined in the the database.

    Regards
    hamhey

  2. #2
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    Hi,

    Check this,

    select directory_path from dba_directories where directory_name=dir_name

    HTH

    Srini

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width