Kumar - Generally, export/import expects to be going to a higher level of
Oracle. If you are moving the data from 8.1.6 to 9i, then that will present
no problems. Going the other way, moving data from 9i to 8.1.6 can pose
problems. The usual recommendation is to use the 8.1.6 "exp" program against
the 9i database.
Are the Linux/W2K files binary compatible. I don't know myself, but
somebody does. Learn the techniques for cloning an Oracle database. I
believe http://www.orafaq.com <http://www.orafaq.com> has a paper on this.
If not, just search using Google.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, August 22, 2002 10:11 AM
To: Multiple recipients of list ORACLE-L
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-----
mailto:[EMAIL PROTECTED]]On Behalf Of DENNIS
WILLIAMS
Sent: Wednesday, August 21, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L
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>
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>
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).
--
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).
