Exp/Imp

[tansdot]

I have a 817 database on NT where I did a Direct path Export.
The characterset is as follows:

select userenv('LANGUAGE') FROM DUAL;

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.WE8ISO8859P1

The Export log says :
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
About to export specified tables via Direct Path ...

The Target database is also 817 on soalris where I did the Import.

The characterset is as follows:

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.WE8ISO8859P1

Import Log says:

Export file created by EXPORT:V08.01.07 via direct path
import done in US7ASCII character set and WE8ISO8859P1 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses WE8ISO8859P1 character set (possible charset conversion)


I thought both the charactersets are the same so why is conversion happening? I checked my data ramdomly I dont see any problem . But am I correct by assuming the above. Or should I redo my export . I dont know its a huge data.

Suggestions appreciated

[roobaron]

Hmm it only said possible conversion.
If you are worried don't use direct path.
Is there any text you could check for possible conversion?
if so check to make sure.
The other alternative is to run the imp from the NT machine across the network to the sun box.

Have Fun

[tansdot]

Can Direct path affect the conversion?

[bill_lee]

You can not do direct exp and imp with different paltforms (NT and Unix).
Conventional exp and Imp should work.

[tansdot]

What do you mean by you cannot do Direct export on different platforms.

I could export by the direct option. Do you mean you should not?

Thanks

[jmodic]

Direct path exports are perfectly transferable and usable (and supported) accros different platforms. So it is totaly viable to export in direct mode for example on NT and then import this dump in the database on Unix.

[tansdot]

Thanks
But could you please explain the cause of my problem.