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

Thread: import

  1. #1
    Join Date
    Oct 2003
    Location
    manila, philipppines
    Posts
    6

    import

    1. I am using Oracle 8.1.7.4 64 bit version.
    2. I am trying to perform an import a schema into a database which was created using UTF8 Characterset
    3. The export file database was created with WE8ISO8859P1

    During the import activity, i got an error as following:

    Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
    With the Partitioning option
    JServer Release 8.1.7.4.0 - 64bit Production

    IMP-00016: required character set conversion (type 31 to 871) not supported
    IMP-00000: Import terminated unsuccessfully

    How to fix this error?
    Cheers!
    SivaRam

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    The export environment charachter set must match the import environment set. So, set your NLS_LANG to UTF8, re-do the export and try it again.

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Oct 2003
    Location
    manila, philipppines
    Posts
    6
    Hey I got the solution

    export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

    execute above command before import.
    Cheers!
    SivaRam

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