Database Administration (MOSC)

MOSC Banner

Import Datapump problems on Oracle 11g

edited Nov 14, 2011 1:02AM in Database Administration (MOSC) 3 commentsAnswered
I am trying to Import (using Datapump) and DMP file from Oracle 10g (10.2.0.4).

The 10g database server has nls_characterset of:

SYSTEM@testers>
PARAMETER                                                                VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_CHARACTERSET                                                 WE8MSWIN1252

1 row selected.

The 11g server has:

SQL> select * from v$nls_parameters
  2  where parameter = upper('nls_characterset');

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_CHARACTERSET
AL32UTF8

Here are the errors:

;;;
Import: Release 11.2.0.2.0 - Production on Tue Nov 8 16:40:11 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
;;;
Connected to: Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center