DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004

    SqlPlus Searching in Multiple Directories


    I was wondering. Is it possible to get SqlPlus to search for scripts
    in multiple directories?

    Ive found advice for setting the directory in the login.sql file for a
    single directory reference but not a reference on how to set multiple
    directories using SQLPATH.

    I have scripts spread across several subdirects. off a root directory.
    I would like sqlplus to read for the named script file in the subdirects., this way I dont have to type in lengthy directory strings before the
    name of the script file in a sqlplus.

    In short, Im trying to run, using START, script files from script files.

    Any advice would be greatly appreciated.

    Would be better attempted using PL/SQL and if so, is there a site
    that gives sample procedures?

  2. #2
    Join Date
    Nov 2005
    Yes.. u can set it different directories using colon.

  3. #3
    Join Date
    Aug 2002
    Colorado Springs
    Not entirely on topic, but you could also consider turning those scripts into stored procedures. There are obviously advantages and disadvantages, but I like the arrangement better myself where it is possible.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.