Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Copy DB From UNIX to Win2K? Hard to do?
Your english is excellent.
On Thu, 25 Jan 2001 17:26:09 +0100, "Annie STECZYCKI" <armoni_at_club-internet.fr> wrote:
>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
>
>
EMail: knijff_at_bigfoot.com Received on Sat Jan 27 2001 - 03:45:27 CST