Oracle-L: RE: Need help and documentation on moving database from Unix to W

From: Baswannappa, Shiva <SXBaswan_at_dcss.com>
Date: Wed, 29 Jan 2003 14:04:39 -0800
Message-ID: <F001.0053DD9B.20030129140439@fatcity.com>

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.
dwilliams_at_lifetouch.com

-----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: DWILLIAMS_at_LIFETOUCH.COM

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: ListGuru_at_fatcity.com (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: SXBaswan_at_dcss.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------