Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problem with Import

Problem with Import

From: jerry <j_at_interia.pl>
Date: Wed, 05 Apr 2006 09:10:16 +0200
Message-ID: <e0vppl$hs0$1@news.interia.pl>


Hi,
I have a problem with import schema to database on Oracle 10 server. Export version: V10.02.01
Import version: 10.1.0.3.0

imp command:
imp userid="usr/pas_at_Example" file="File.dmp" log=importLog fromuser=SomeUser touser=usr IGNORE=Y

User 'usr' has DBA privileges.

The error during this operation is below:

IMP-00017: following statement failed with ORACLE error 2248:   "ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL = 2 NLS_LENGTH_SEMANTICS =
'BYTE' PL"

  "SQL_CODE_TYPE = 'INTERPRETED' PLSQL_DEBUG = FALSE PLSQL_WARNINGS =
'DISABLE"

  ":ALL'PLSQL_CCFLAGS = ''"

IMP-00003: ORACLE error 2248 encountered
ORA-02248: invalid option for ALTER SESSION
IMP-00000: Import terminated unsuccessfully

Thanks for any suggestion.
jerry Received on Wed Apr 05 2006 - 02:10:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US