[oracle1@WBDevelop smbshare]$ exp lab/lab@wbdata.wbh-db1 

Export: Release 9.2.0.1.0 - Production on Tue Dec 28 15:45:32 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp > lab

(2)U(sers), or (3)T(ables): (2)U >

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in US7ASCII character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user LAB
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user LAB
About to export LAB's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export LAB's tables via Conventional Path ...
. . exporting table                  BLENDSAMPLEDC        620 rows exported
. . exporting table                         JCTEMP        620 rows exported
. . exporting table                       SAMPLEDC        133 rows exported
. . exporting table                 SAMPLERECEIVEA        131 rows exported
. . exporting table                 SAMPLERECEIVEB        815 rows exported
. . exporting table                 SAMPLETESTINGA        815 rows exported
. . exporting table                 SAMPLETESTINGB      15485 rows exported
. . exporting table                  SAVESTATS_LAB       1601 rows exported
. . exporting table              TESTING_PARAMETER         19 rows exported
. . exporting table                 TRADESAMPLEDCA        213 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

(Export taken from Oracle11g via use of 'wbdata.wbh-db1' service)

[oracle1@WBDevelop smbshare]$ imp lab/lab

Import: Release 9.2.0.1.0 - Production on Tue Dec 28 15:49:51 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Import file: expdat.dmp > lab

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
IMP-00003: ORACLE error 96 encountered
ORA-00096: invalid value  for parameter plsql_compiler_flags, must be from among
 NON_DEBUG, DEBUG, INTERPRETED, NATIVE
IMP-00000: Import terminated unsuccessfully

SQL> show parameter plsql_compiler_flags 

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
plsql_compiler_flags                 string      INTERPRETED

SQL> select 'session' who, value
  2  from v$nls_parameters
  3  where parameter = 'NLS_CHARACTERSET'
  4  union all
  5  select 'database', value
  6  from nls_database_parameters
  7  where parameter = 'NLS_CHARACTERSET'
  8  /

WHO      VALUE
-------- ----------------------------------------------------------------
session  US7ASCII
database US7ASCII

SQL> select * from v$nls_parameters where PARAMETER = 'NLS_NCHAR_CHARACTERSET';

PARAMETER                                                        VALUE
---------------------------------------------------------------- --------------------
NLS_NCHAR_CHARACTERSET                                           AL16UTF16

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL> select 'session' who, value
  2  from v$nls_parameters
  3  where parameter = 'NLS_CHARACTERSET'
  4  union all
  5  select 'database', value
  6  from nls_database_parameters
  7  where parameter = 'NLS_CHARACTERSET'
  8  /

WHO      VALUE
-------- ----------------------------------------------------------------
session  US7ASCII
database US7ASCII

SQL> select * from v$nls_parameters where PARAMETER = 'NLS_NCHAR_CHARACTERSET';

PARAMETER                                                        VALUE
---------------------------------------------------------------- ------------------
NLS_NCHAR_CHARACTERSET                                           AL16UTF16

SQL> show parameter plsql_compiler_flags;
SQL>