Unix Technical Forum

New to Oracle question (Exp/imp): THanks!

This is a discussion on New to Oracle question (Exp/imp): THanks! within the Oracle Database forums, part of the Database Server Software category; --> Thank you to Rauf and MBPP for answering the question below. I'd have posted this as a reply, but ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-24-2008, 10:28 AM
James Tilby
 
Posts: n/a
Default New to Oracle question (Exp/imp): THanks!

Thank you to Rauf and MBPP for answering the question below. I'd have
posted this as a reply, but Google isn't obliging...

Thanks again

James


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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:44 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com