Re: New to Oracle question (Exp/imp)

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 19 Jan 2005 04:40:43 -0800
Message-ID: <1106138443.926835.205830@c13g2000cwb.googlegroups.com>

James Tilby wrote:
> Hi all,
>
> I wondered if someone knew the answer to this question about the
> Oracle imp/exp tools.
>
> If I have a Windows based Oracle server, can I export a database
using
> exp from that server, and then re-import it onto Unix based Oracle
> Server? In both cases, I would be working with Windows based oracle
> client software. The servers would also be the same major release
> (9.2.x).
>
> Thanks,
>
> James

Yes you can export/import over the SQL*Net/Net8/Net9. Just be aware that you use the exp release of the lower version out of the two databases. Imp release must be the same as target database. Also there may be excessive characterset converions if both databases and your client session have different character sets. To avoid this, set your client NLS_LANG to same characterset as source database before export. Before import, set your client NLS_LANG to same characterset as target database.

Regards
/Rauf Received on Wed Jan 19 2005 - 06:40:43 CST