Do you have Oracle Designer loaded?


Jeffrey C. Ferrel
DMS III
State of Nevada
775.687.9327
[Email address protected]


-----Original Message-----
From: Purusottam Kaushik
[mailto:oracledba-ezmlmshield-x64676211.[Email address protected]
Sent: Wednesday, May 30, 2007 10:01 AM
To: LazyDBA Discussion
Subject: Import Problem

Hi ORACLE GURUS,



While performing import on oracle 10G my import command terminate with
following error.



. . importing table "ZIPS" 73136 rows
imported

IMP-00017: following statement failed with ORACLE error 2248:

"ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL = 1 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



Please help me with problem. Thanks in advance.



Thanks

Purusottam Kaushik





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page