Results 1 to 3 of 3

Thread: How to know which record is not inserted

  1. 04-26-2008 #1
    aurobinda.dalai
    aurobinda.dalai is offline
    Junior Member
    Join Date
    Mar 2008
    Answers
    2

    How to know which record is not inserted

    Suppose we have insert 1000 records into a table .suppose 800th record is not inserted. How can we know that 800th record is not inserted.

    Reply With Quote Reply With Quote
  2. 04-26-2008 #2
    krishnaindia2007
    krishnaindia2007 is offline
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: How to know which record is not inserted

    Quote Originally Posted by aurobinda.dalai View Post
    Suppose we have insert 1000 records into a table .suppose 800th record is not inserted. How can we know that 800th record is not inserted.
    Which utility are you using?

    You can get the details of rejected records, reason for rejection can be found from log file.

    Reply With Quote Reply With Quote
  3. 04-28-2008 #3
    debasisdas
    debasisdas is offline
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074
    Send a message via ICQ to debasisdas Send a message via AIM to debasisdas How to know which record is not inserted

    Re: How to know which record is not inserted

    if using sql*loader then check the log file as wellas the bad file.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact