Create directory in DB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Create directory in DB

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    14

    Talking

    Hi,

    If I create a directory for loading files in to clobs via a stored proc do I need to register the Unix dir in utl_file_dir in init.ora?

    i.e.
    create directory test as '/tmp';

    The SP will access test to load files into CLOBS using the
    DBMS_LOB package.

    regards,

    MCL

  2. #2
    Join Date
    Jan 2001
    Posts
    515

    yes

    yes you have to register the directory in util_file parameter.Oracle also has to have right to that directory in unix.

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