DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2000
    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?

    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?

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

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

  3. #3
    Join Date
    Oct 2000
    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

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