4 Replies Latest reply: Jul 5, 2013 12:03 AM by Rizwan Shaukat RSS

    I export dump from oracle database 8.1.7 and try to import in 10.2.0. while import its prompt error

    Rizwan Shaukat

      I export dump from oracle database 8.1.7 and try to import in 10.2.0. while import its prompt error as follow

       

      8.1.7

      SQL> select * from nls_database_parameters where parameter like '%SET%';

       

       

      PARAMETER                      VALUE

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

      NLS_CHARACTERSET               US7ASCII

      NLS_NCHAR_CHARACTERSET         US7ASCII

       

      10.2.0

      SQL> select * from nls_database_parameters where parameter like '%SET%';

       

       

      PARAMETER                      VALUE

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

      NLS_NCHAR_CHARACTERSET         AL16UTF16

      NLS_CHARACTERSET               WE8MSWIN1252

       

      C:\Documents and Settings\Administrator>imp system/manager file=H:\CGlByte\cglby

      te_03-07-2013Wed.dmp fromuser=system touser=cglbyte ignore=y

       

       

      Import: Release 10.2.0.4.0 - Production on Thu Jul 4 16:11:49 2013

       

       

      Copyright (c) 1982, 2007, Oracle.  All rights reserved.

       

       

       

       

      Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Produc

      tion

      With the Partitioning, OLAP, Data Mining and Real Application Testing options

       

       

      Export file created by EXPORT:V08.01.07 via conventional path

      import done in US7ASCII character set and AL16UTF16 NCHAR character set

      import server uses WE8MSWIN1252 character set (possible charset conversion)

      export client uses WE8ISO8859P1 character set (possible charset conversion)

      export server uses US7ASCII NCHAR character set (possible ncharset conversion)

      Import terminated successfully without warnings.

       

      Pl suggest remedy

       

      Regards,