DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: import

  1. 12-16-2002, 06:28 AM #1
    albaghdady
    albaghdady is offline Junior Member
    Join Date
    Dec 2002
    Posts
    1

    import

    is there any parameter that i can use to distinguish between import failure and import success with warning.

    the point is, i need to rollback if import failed or completed with warnings.
    i'm using oracle 7, tel me if i need to upgrade to overcome this

    please advise
    thanx
    Reply With Quote Reply With Quote
  2. 12-16-2002, 06:37 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    If you use unix...

    You can use the exit state of the import to perform specific actions or you can write the import to a log file and then grep the log for errors.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  3. 12-17-2002, 09:39 AM #3
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    I belive this peace of code should fit ur requirement..

    WHENEVER SQLERROR EXIT 5 ROLLBACK

    Abhay.
    Reply With Quote Reply With Quote
  4. 12-17-2002, 09:46 AM #4
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    I belive this peace of code should fit ur requirement..

    WHENEVER SQLERROR EXIT 5 ROLLBACK

    Abhay.
    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

Click Here to Expand Forum to Full Width