Home » RDBMS Server » Server Administration » Migration EXPORT db from windows and IMPORT to db on unix
Migration EXPORT db from windows and IMPORT to db on unix [message #59162] Sat, 01 November 2003 18:15 Go to next message
Yhab
Messages: 7
Registered: October 2003
Junior Member
Hi all,
Migration question : from win to unix

I have a database on windows system, and I want to migrate to unix.

Say we talk about the same release on two environments,

- Generate a orclwin.dmp with export command on windows system
- ftp the orcl.dmp file from windows to Unix
- import orclwin to orclunx database

Is that write ?

Thanks
yhab

Report message to a moderator

Re: Migration EXPORT db from windows and IMPORT to db on unix [message #59168 is a reply to message #59162] Sun, 02 November 2003 06:54 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Right, just make sure to use the same RECORDLENGTH parameter in both exp and imp.
Also try to retain the same NLS_LANG environmental variable on both sides.
Ftp in binary mode.
These are in addition to other things like tablespace space, privileges etc..

HTH
Thiru

Report message to a moderator

Previous Topic: PARTITIONING
Next Topic: Migration
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:20:34 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.