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

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