Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Problem with Import
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