OraFAQ Forum: Server Utilities » ORA-02248: invalid option for ALTER SESSION

Home » RDBMS Server » Server Utilities » ORA-02248: invalid option for ALTER SESSION (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-02248: invalid option for ALTER SESSION [message #332115]

Mon, 07 July 2008 09:45

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Hi,
While i am trying to import a schema i get the following error ,so pls help on this

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

Thanks,

Report message to a moderator

Re: ORA-02248: invalid option for ALTER SESSION [message #332117 is a reply to message #332115]

Mon, 07 July 2008 09:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

Report message to a moderator

Re: ORA-02248: invalid option for ALTER SESSION [message #332118 is a reply to message #332115]

Mon, 07 July 2008 09:52

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Seems there is a mismatch between the exp version you used to export and imp version you are using to import.
Always use the lower version to export and the same lower version to import.

Report message to a moderator

Previous Topic:	trace files
Next Topic:	sequences & IMP-00015: following statement failed because the object already exists:

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 02 01:12:58 CDT 2026