Oracle Import Alert
Posted on 2006-05-15
I have 2 questions. I'm importing an oracle schema from an Oracle 8i database into an Oracle 9i database. The data comes thru fine but I get an alert message right before it starts importing complaining about the character set. It states the following...
Connected to: Oracle 9i Release 126.96.36.199.0 - Production
JServer Release 188.8.131.52.0 - Production
Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses WE8ISO8859P1 character set (possible charset conversion)
export server uses WE8ISO8859P1 character set (possible ncharset conversion)
1) How do I set the character set for the import utility? What am I doing wrong? I'm a bit confused here. This is the most important question.
2) Another related issue to the import is that none of the "grants" come thru on the import. I'm sure I'm doing something wrong. Any thoughts?
Thx for the help...