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: 25035
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: 10672
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: Sat Dec 03 15:52:07 CST 2016

Total time taken to generate the page: 0.15946 seconds