RE: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux 7.

[Dharminder Kumar]

Dennis,
In my case Net8 connection is not feasible because I have both OS Windows 2000/ Linux on the same machine using dual boot. So the only option for me is to export the required user from Windows database  and then import from Linux database. But please note that I have source database Windows 2000/9i, but the source database is Linux/8.1.6. Can this be any problem for export/import.

Recently I copied a database from a Window machine to another window machine by copying the database files, redo log file, control files etc to target machine in the corresponding directory and just created a service on the target machine by using oradim and it worked fine. Is that possible if you want to move the database and other files of Windows OS database to a Linux OS database and then use svrmgrl to do something similar to get windows database working on Linux. I know for this to work, I need to recreate or make changes to control file.

Thanks.


-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of DENNIS
WILLIAMS
Sent: Wednesday, August 21, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux
7.


Kumar
   Ummm . . . are you using any 9i features? I'm assuming you have
considered using 9i on Red Hat. Sounds like probably use the 8i export
function to create the export file. I'm assuming the data involved is small
enough to make export/import practical. If you create a Net8 connection, you
can just copy the data.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-----Original Message-----
Sent: Wednesday, August 21, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L
8.1.6


I want to move the Windows 2000/ Oracle 9i database to Linux Red Hat 7.1/
Oracle 8.1.6. Please suggest the options.

Thanks.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dharminder Kumar
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).