Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Copy DB From UNIX to Win2K? Hard to do?

Re: Copy DB From UNIX to Win2K? Hard to do?

From: Annie STECZYCKI <armoni_at_club-internet.fr>
Date: Thu, 25 Jan 2001 17:26:09 +0100
Message-ID: <94pk68$ive$1@front2m.grolier.fr>

Hello,

Well,i don't speak very well english (i'm french).

It's not very difficult!

  1. create database on win2k with the same character set and national character set than the database on Unix
  2. execute on this new database the scripts "catalog" and "catproc"
  3. create the tablespaces with the same name than on Unix
  4. Export the database full on Unix (don't forget to set NLS_LANG to good value)
  5. Transfer the import on win2k (mode binary with ftp)
  6. Import in the new database with option "ignore=Y" (don't forget to set NLS_LANG to good value)

Warning: You must care with the initial extent because with export the default option "compress" is yes and perhaps you have not sufficient contiguous space on win2k; So you must use option "compress=n" in statement 4;

I think it's a good way to do what you want (see doc for details or post again)

Annie Steczycki Received on Thu Jan 25 2001 - 10:26:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US