Thanks everybody I have performed it on a smaller test machine and will do the production database import/export tonight.
Regards Shiva -----Original Message----- Sent: Wednesday, January 29, 2003 2:00 PM To: Multiple recipients of list ORACLE-L W Shiva First I would suggest you consider whether this is a good use of your client's money. This is a somewhat complex task that will be a good learning experience for you personally, but may cost the client. You should also consider how you will be able to confirm the quality of your work once you are done. Will you be able to ensure the client will have a robust Oracle database they can rely on? Overall the steps are: Install Oracle on Windows. Create a database, with the same usernames and tablespaces as the Unix database. Perform a full export of the data. Import the data into the Windows database. Verify that the import was successful and no data was lost. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, January 29, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Hi Gurus I am not a DBA, but I have request from client to move their oracle 8.1.6 database from a Unix server to W2K. Can somebody lead me to documentation in moving entire DB or any other resource that will help me accomplish the task? Thanks a ton in advance Regards Shiva Baswannappa Senior Developer Digital Consulting and Software Services Phone: 281.243.2658 Fax: 281.243.2504 Web: http://www.dcss.com <http://www.dcss.com/> If the reader of this e-mail is not an intended recipient, you have received this e-mail in error and any review, dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by return e-mail and permanently delete the copy you received. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Baswannappa, Shiva INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).