1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

importing oracle 10g dump file in oracle 11g

Discussion in 'Installation - Windows' started by ksjj, Feb 20, 2013.

  1. ksjj

    ksjj Active Member

    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    80
    HI,

    I work on oracle 10g and devsuite 9i forms and reports on linux environment. its working fine. i installed oracle 11g and devsuite 11g forms and report in my laptop and imported oracle 10g dump file .

    I compiled all forms and i could get the login screen . when i tried to connect it to the database it gives this error

    FRM 40735 - ON ERROR TRIGGER RAISED UNHANDLED EXCEPTION -ORA 06508

    when i looked at the imp log file , it looks like all views have got imported with compilation error

    imp -00041 - warning: object created with compilation warnings.

    is this the problem . how do i import both tables and view

    i used this query to import oracle 10g dump file in command prompt

    imp file =<file name.dmp> fromuser=myuser touser=myuser buffer
    0000 commit=y log=imp.log

    it would be great if anyone could suggest some help to solve this issue

    thanks in advance

    narayan
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You need to know WHY the views are invalid; you will need to compile at least ONE of them to see if it will compile. If not you need to type 'show errors' at the SQL> prompt to reveal WHY the compilation failed.
     
  3. ksjj

    ksjj Active Member

    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    80
    sir,

    I compiled all views , proceedures, packagaes, functions . I deleted the library from all the forms and attached it again. what i observed is one of the main library file does not get compiled , but the same pll file when i tried compiling it my server system it gets compiled without error.
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi,

    Whats the error you are getting ?