insert problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: insert problem

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    I tried to insert some rows into a table and I got this errors


    ORA-03113: end of file on communication channel.

    please advise



  2. #2
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    You lost connection to database or the instance is shutdown, reconnect and try again, it should work if the instance is up.

    KN

  3. #3
    Join Date
    Jan 2002
    Posts
    474
    Thanks for your reply, the problem is not I got disconnect and reconnect and run.

    The problem is my connection will be disconnect everytime I ran this insert statement. I do believe that it's a bug in ORacle

    by the way, I am running 8.1.7 on windows 2000 server.


  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Possibly. What did your alert.log and trace file say?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Jul 2000
    Posts
    521
    What tool are you using for starting the insert ?
    Is it a GUI program? SQL*Plus ?

    What type of data are you trying to insert ?
    svk

  6. #6
    Join Date
    Jan 2002
    Posts
    474
    That's Oracle bug. It works now after I add one parameter to work around without applying the patch

    Thank you all

  7. #7
    Join Date
    Jul 2000
    Posts
    521
    Hey.....will you please educate all of us here @ what parameter helped you ?
    svk

  8. #8
    Join Date
    Jan 2002
    Posts
    474
    bug number 1099596 or you can add this parameter :_IGNORE_DESC_IN_INDEX = TRUE

    thats should do


    can someone please help me to tune this query ??? I posted it in here twice, but I guess it was removed for some reason.

    here is the query and it Oracle Spatial:

    SELECT b.grid_key,
    b.grid_lvl1_key, b.grid_lvl1_code, b.grid_lvl1_name,
    b.grid_lvl2_key, b.grid_lvl2_code, b.grid_lvl2_name, b.grid_fips_st_code
    FROM grid_master a, grid_master b, USER_SDO_GEOM_METADATA M
    WHERE m.table_name = 'GRID_MASTER' AND m.column_name = 'SOB_GEOMETRY'
    AND SDO_RELATE(A.sob_geometry, B.sob_geometry,'mask=inside querytype=WINDOWDS') = 'TRUE' AND a.grid_key=6909 and b.grid_lvl = a.grid_lvl -1;

    Thanks



  9. #9
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    FYI: It was not removed, instead it had been moved to the development forum.


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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