Can I run sqlldr in sqlplus?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Can I run sqlldr in sqlplus?

  1. #1
    Join Date
    Jun 2001
    Posts
    243
    We have some issues about sqlldr. Our roles are set default to none and when we login to sqlplus or any application, we set role in order to run the appliations. And there is a problem running sqlldr since I can't set role after i'm in the sqlldr utility. So my question is

    1) Can I SET ROLES in sqlldr in Sun Solaris?

    2) Can I run sqlldr from sqlplus from Sun Solaris?

    for ex: from unix, I type sqlplus
    login/password
    I'm in the sqlplus> can I run sqlldr here?



  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Maybe you can use in sqlplus the command host to run sqlldr

    Host: It is used for running OS commands in sqlplus

    Cheers

    Angel

  3. #3
    Join Date
    Jun 2001
    Posts
    243
    ok....this is what's going on.

    from unix:
    1. sqlplus
    2. username/password
    3. sqlplus> SET ROLE role_name;
    4. sqlplus> role set.
    5. sqlplus> host sqlldr
    6. but when you are in sqlldr they ask for username and password again. once I type username and password again, Is my role still set or not? If I type in username/password again inside the sqlldr, am I in same session as sqlplus or not?

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by gaegoori

    Can I run sqlldr from sqlplus from Sun Solaris?
    Yes, but it is not straightfoward. Install JVM and follow the instructions at http://www.oracle-base.com/Articles/...sFromPLSQL.asp

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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