| Problem in Importing database from heigher to lower version [message #51340] |
Thu, 16 May 2002 07:13  |
Soman Singh
Messages: 2
Registered: May 2002
|
Junior Member |
|
|
Hi!,
I am trying to import .dmp file from oracle 8.7.1 to 8.6.1.
Few thigs I would like to know are:
1. Is backward compatibility possible???
2. I get the error upon importing the data which is most common...
Import done in WE8IS08859P1 charecter set and US7ASCII NCHAR character set.
export client uses WE8IS08859P1 character set (possible charset conversion)
import server uses US7ASCII NCHAR character set (possible ncharset conversion)
I tried to set the NLS_LANG in the classpath but in vain....
Also tried by ALTER COMMAND ....but no way
Are there any ways I can solve the Problem....
Any quick help shall be helpful to me...
Thanks in advance...
Regards,
Soman
|
|
|
|
|
|
|
|
|
|
| Re: Problem in Importing database from heigher to lower version [message #51353 is a reply to message #51340] |
Fri, 17 May 2002 05:39  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
You will need to perform the export using the 8.1.6 binaries. On the 8.1.6 machine make sure you have a tns entry for the 8.1.7 machine and type:
exp system/PASSWORD@tns817 ...
This will export the 8.1.7 database using the 8.1.6 binaries.
When going down version you need to use the target (in this case 8.1.6) dbase version export.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
