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

Thread: Import Error

  1. #1
    Join Date
    Apr 2004
    Posts
    14

    Import Error

    While importing i am getting the following errors.

    IMP-00017: following statement failed with ORACLE error 604:
    "COMMENT ON COLUMN "IP_USER_ROLE_MAST"."USER_ROLE_DESC" IS 'This column is "
    "used store the description of role'"
    IMP-00003: ORACLE error 604 encountered
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01401: inserted value too large for column
    ORA-06512: at line 2

    Why i am getting the error and how to avoid it.

    Regards

    Pradipta

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    From the error message it seems that the table into which you are importing has diff column length (smaller) than the table from which data was exported.

    Increase the size of the table column...

    More details would have been helpful....
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    It's posts like this that really piss me off.

    1. Go look on metalink first! If you don't have an account go get one. If you don't know what Metalink is you shouldn't be a DBA.

    Why i am getting the error and how to avoid it.
    2. No "can anyone here help me out please?" Just here's my error now tell me how to fix it. Grrrrrrrrr!!!
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  4. #4
    Join Date
    Apr 2004
    Posts
    14
    ----------------------------------------------------------------
    It's posts like this that really piss me off.

    1. Go look on metalink first! If you don't have an account go get one. If you don't know what Metalink is you shouldn't be a DBA.
    quote:
    --------------------------------------------------------------------------------
    Why i am getting the error and how to avoid it.
    ----------------------------------------------------------------------
    2. No "can anyone here help me out please?" Just here's my error now tell me how to fix it. Grrrrrrrrr!!!

    ---------------------------------------------------------------------


    Dear friend,

    If you don't know the reply keep your mouth shut.

    Regards

    Pradipta

  5. #5
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Dear Friend,
    You are absolutely right,how horrible of me. You can find help with solving your problem here

    If that doesn't help, let me know and I'll be more than happy to post a script here that will solve your entire problem.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  6. #6
    Join Date
    Apr 2004
    Posts
    14
    Hi Friend,

    I regret for my behavior, sorry for the same.

    regards

    Pradipta

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