| import problems [message #260303] |
Sat, 18 August 2007 04:51  |
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 #260353 is a reply to message #260303] |
Sat, 18 August 2007 23:26  |
 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
