Re: export a windows database from linux

Exporting a Windoze database from Linux will work without any problem.

What might give you problems:
  Different Oracle versions
  Incorrect NLS_LANG settings.

Export will complain about both.

Export will do character set conversions, but my personal preference is to just temporarily set NLS_LANG on the linux side so that it matches the character set of database being exported.

Also be careful of difference database character sets. You can for instance import US7ASCII into WE8ISO8859P1 without any problem, but the reverse may not be true, dependent on the data.

There are others on this list that can speak to NLS issues with some authority,
so maybe one of them will chime in.

Jared

On 12/22/05, Jeffrey Beckstrom wrote:
>
> Source database is 9.2.0.6 on windows. Target is 9.2.0.7 on Linux. Instead
> of exporting on windows, ftp'ing the dump to Linux and then running an
> import. Could I run export on Linux against the Windows database. This would
> eliminate the ftp step since going right to the linux system during the
> export.
>
> Usually want export to be same version as the database, but since both 9i,
> could I do this?
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist