Home » RDBMS Server » Server Utilities » import problems
import problems [message #260303] Sat, 18 August 2007 04:51 Go to next message
pvr_msg
Messages: 7
Registered: August 2006
Location: hyderabad
Junior Member
Hi to all,

Plz Give solution for my doubt

Is it possible to import oracle10g relese2 dump into oacle10g relese1 version database.When i import 10g relese2 dump into 10g relese1 database the following error occur


IMP-00003: ORACLE error 2248 encountered
ORA-02248: invalid option for ALTER SESSION
IMP-00000: Import terminated unsuccessfully

Re: import problems [message #260304 is a reply to message #260303] Sat, 18 August 2007 04:55 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Are you using ALTER SESSION?

Desc: ORA-02248 invalid option for ALTER SESSION
Cause: An option other than SET EVENTS was found following the ALTER SESSION command.
Action: Specify the SET EVENTS option after the ALTER SESSION command, and try again.

By
Vamsi
Re: import problems [message #260305 is a reply to message #260303] Sat, 18 August 2007 04:59 Go to previous messageGo to next message
pvr_msg
Messages: 7
Registered: August 2006
Location: hyderabad
Junior Member
I can't understand plz explain in detail
Re: import problems [message #260310 is a reply to message #260305] Sat, 18 August 2007 05:22 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Check this.
Quote:
Are you using ALTER SESSION somewhere?

By
Vamsi
Re: import problems [message #260347 is a reply to message #260303] Sat, 18 August 2007 22:02 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Importing into lower version from exported upper version raise this error.I can suggest you to use data pump.
Re: import problems [message #260353 is a reply to message #260303] Sat, 18 August 2007 23:26 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
pvr_msg wrote on Sat, 18 August 2007 05:51

Is it possible to import oracle10g relese2 dump into oacle10g relese1 version database.

No, if the 10gR2 dump file was produced with the 10gR2 export utility. However, if you still want to use the export/import utilities, you should export from the 10gR2 database while using the 10gR1 export utility. Once the data has been exported, you should use the 10gR1 import utility to import the dump file into the 10gR1 database.
Previous Topic: Ssql*Loader - Ignoring certain columns while loading
Next Topic: Multiple fields terminations
Goto Forum:
  


Current Time: Fri Dec 09 15:42:38 CST 2016

Total time taken to generate the page: 0.10840 seconds