Import Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Import Problem

  1. #1
    Join Date
    Aug 2001
    Posts
    56

    Import Problem

    Hi
    I have importing from 8.1.6 version. and the xported file from 8.1.7.
    it is also showing some NCHAR charecter set.
    actually its a version probel....or what..

    the msg is.



    $ imp al/pw4al file=algo.dmp

    Import: Release 8.1.6.0.0 - Production on Fri Dec 20 09:57:22 2002

    (c) Copyright 1999 Oracle Corporation. All rights reserved.


    Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.0.0 - Production

    Export file created by EXPORT:V08.01.07 via conventional path
    import done in US7ASCII character set and US7ASCII NCHAR character set
    IMP-00069: Could not convert to environment national character set's handle
    IMP-00000: Import terminated unsuccessfully
    Anuj
    India

  2. #2
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Check your national character set(nchar) at then if its not us7ascii
    then
    ALTER DATABASE SET NATIONAL
    CHARACTERSET "US7ASCII"


    That should hopefully fix it.
    Also, read the following note 181508.1
    Last edited by jlakhani; 12-19-2002 at 11:29 AM.
    "High Salaries = Happiness = Project Success."

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    have you exported using exp 8.1.6 and imported with imp 8.1.6?

    change your NLS_LANG to a proper one, you have to see that from the server where you exported

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