Find the answer to your Linux question:
Results 1 to 3 of 3
I have error text message as follows; SQL*Loader: Release 10.2.0.5.0 - Production on Mon Apr 15 SQL*Loader-601: For INSERT option, table must be empty I want to search a certain ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Oct 2012
    Posts
    24

    how to search word,SQL*Loader-


    I have error text message as follows;
    SQL*Loader: Release 10.2.0.5.0 - Production on Mon Apr 15
    SQL*Loader-601: For INSERT option, table must be empty

    I want to search a certain word, SQL*Loader-
    If i do;
    grep "SQL*Loader-" glob_cfg_bds_definitions.log
    or
    grep -i "SQL*Loader-601" glob_cfg_bds_definitions.log

    There is no output.

    would you please help me to get the result.
    Thanks in advance.

  2. #2
    Just Joined!
    Join Date
    Dec 2012
    Posts
    30
    Try escaping the * and - characters with backslashes, like this:

    Code:
    grep "SQL\*Loader\-" glob_cfg_bds_definitions.log

  3. #3
    Just Joined!
    Join Date
    Oct 2012
    Posts
    24
    Thank You so much for your help!!!!

  4. $spacer_open
    $spacer_close

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •