Home » RDBMS Server » Server Administration » IMP-00003: ORACLE error 2248 encountered
IMP-00003: ORACLE error 2248 encountered [message #125781] Wed, 29 June 2005 04:18 Go to next message
confident
Messages: 28
Registered: March 2005
Junior Member
hi friends,

we have two database server one is oracle 9.2.0.4 and oracle 8.1.7.. iam doing the export of some tables from 9i database and trying to import in 8.1.7 database using 9.0.1 client, iam facing error

Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and UTF8 NCHAR character set
import server uses UTF8 character set (possible charset conversion)

IMP-00003: ORACLE error 2248 encountered
ORA-02248: invalid option for ALTER SESSION

IMP-00000: Import terminated unsuccessfully

is there any solution for this error...

Report message to a moderator

Re: IMP-00003: ORACLE error 2248 encountered [message #125793 is a reply to message #125781] Wed, 29 June 2005 04:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use 8.1.7 client to export and 8.1.7 client to import

Report message to a moderator

Re: IMP-00003: ORACLE error 2248 encountered [message #125866 is a reply to message #125781] Wed, 29 June 2005 10:32 Go to previous message
confident
Messages: 28
Registered: March 2005
Junior Member
and i tried export from oracle 8.1.7 binary to export the 9i database table, but its error product segmentation fault error(coredump)

Report message to a moderator

Previous Topic: ORA-04031: unable to allocate 44352 bytes of shared memory
Next Topic: Strange Export Error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 00:15:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.