Import Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Import Error

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    Import Error

    i am getting the error while i am trying to import schema into test Db server
    Can anybody help me in this regard?

    "CREATE FORCE VIEW "NCTEXMIS"."VEW_ERP_COUNTRY"
    "NTRY_CODE","COUNTRY_NAME") AS "
    "select C.COUNTRY_ID AS COUNTRY_CODE,"
    " C.COUNTRY_DESC AS COUNTRY_NAME"
    " from WIZ_COUNTRY_MT@NCTEXTOERP C"
    "WITH READ ONLY"
    IMP-00003: ORACLE error 12535 encountered
    ORA-12535: TNSperation timed out

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    you operation timed out and you lost connection - start again

  3. #3
    Join Date
    Sep 2006
    Posts
    114
    Quote Originally Posted by M.Shakeel Azeem
    i am getting the error while i am trying to import schema into test Db server
    Can anybody help me in this regard?

    "CREATE FORCE VIEW "NCTEXMIS"."VEW_ERP_COUNTRY"
    "NTRY_CODE","COUNTRY_NAME") AS "
    "select C.COUNTRY_ID AS COUNTRY_CODE,"
    " C.COUNTRY_DESC AS COUNTRY_NAME"
    " from WIZ_COUNTRY_MT@NCTEXTOERP C"
    "WITH READ ONLY"
    IMP-00003: ORACLE error 12535 encountered
    ORA-12535: TNSperation timed out
    i have copied dump file on my test Db server where i want to import it ,this machine is up and running and Db services are also running
    So what could be the reason now?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    same as before

  5. #5
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    If your dump is local then don't use tns
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

  6. #6
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    trying to create a view with dblink as reference.

    try to ignore this error.

    create a dblink after then.
    and
    manually create the view.
    ---------------

  7. #7
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    ORA-12535: TNSperation timed out
    is raised due to the dblink trying to access another db.
    ---------------

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