Home » RDBMS Server » Server Utilities » ORA-02248: invalid option for ALTER SESSION (oracle 10g)
ORA-02248: invalid option for ALTER SESSION [message #332115] Mon, 07 July 2008 09:45 Go to next message
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,
Re: ORA-02248: invalid option for ALTER SESSION [message #332117 is a reply to message #332115] Mon, 07 July 2008 09:47 Go to previous messageGo to next message
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
Re: ORA-02248: invalid option for ALTER SESSION [message #332118 is a reply to message #332115] Mon, 07 July 2008 09:52 Go to previous message
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.
Previous Topic: trace files
Next Topic: sequences & IMP-00015: following statement failed because the object already exists:
Goto Forum:
  


Current Time: Tue Dec 24 10:00:39 CST 2024