sql loader invocation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sql loader invocation

  1. #1
    Join Date
    Oct 2000
    Posts
    211
    Hi guys
    I am getting the followin error while invoking the sql loader from c prompt.(c:>sqlldr)
    " The name specified is not recognised as an internal or external command, operable program or batch file".
    The same command used to work fine a few days back. What is the problem, can some one help me?
    thanks
    manjunath


    And while using the Load option from Enterprise manager I am getting the following error:

    Record 1: Rejected - Error on table CRDB.TOLL_FREE_NUMBER, column CORPORATION_ID.
    ORA-01722: invalid number

    The records areCORPORATION_ID Number and TOLL_FREE_NUMBER varchar2(10), both stored in an .xls file. Earlier Igot the error as the record are too many(more than 65536) and i reduced the rows size for this. Any other way to go around it?
    thanks



    [Edited by manjunathk on 11-16-2000 at 02:00 PM]

  2. #2
    Join Date
    Nov 1999
    Location
    Elbert, Colorado, USA
    Posts
    81
    It sounds like your PATH setting may have changed. Have you verified that the file still exists?

  3. #3
    Join Date
    Oct 2000
    Posts
    211
    thanks, carp
    somehow the sqlldr file seems to have missed while i loaded the oracle client a few days back. guess i need to reinstall it again. Anyway, what may be the solution using Load from enterprise (Data)manager?

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