Hi Dennis,
Thanks for your quick response. I do appreciate it very much. Unfortunately, I am not a person who can make a decision. Since my boss wants to go with the latest version of Oracle, so I am assigned to do research on this matter.
Yes, I am currently running Oracle8.1.7 on my system. But this server is only serving as a development database. Therefore, I had installed the downloaded Oracle software from Oracle.com on my system and it works very well. Now, I need to set up a brand new production database with an Oracle license in order to load very huge data on it before tranferring to the remote Oracle8.1.7 server site. Since I have not done anything like this before, so I really spend a lot of time to work on the compatibility issues. To make this matter simple, of course Oracle 8.1.7 database is perfect match with my client's server. But, I am not in the position to make it happen. Will see if I can convince my boss to change his mind.
Any help is greatly appreciated. Again, thanks for your input.
Lenka
DENNIS WILLIAMS <[EMAIL PROTECTED]>wrote:
Nguyen - If your client is important to you, why not install 8.1.7 on your
system? You can run two instances on almost every system today. Then you
will have fewer compatibility issues and serve your client better.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, August 26, 2002 6:58 PM
To: Multiple recipients of list ORACLE-L
server
Hi All,
I received all good anwers and documentation from the list about using
export/import utilities to transfer data between two different versions of
databases. (Oracle9i & 8i). Just wanted to know whether I do need to
downgrade my Oracle9.0.2 database server to release 8.1.7 in order to make
it compatible with my client's server or not?
I plan to set up a brand new Oracle9.0.2 server very soon. Just wanted to
seek y! ! our good advice of which version of oracle (9.0.2 or 8.1.7) I should
go for. Since I read the documentation on this link
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920
/a96530/downgrad.htm#1008879
0/a96530/downgrad.htm#1008879>
and found that it is not fun at all to downgrade the entire Oracle9.0.2 in
order to work with my remote Oracle8.1.7 server. Please direct me what to
do. Your help is greatly appreciated.
Thanks in advance.
Lenka
Just wanted to have exact copy of my Oracle9i database server on Suse Linux
7.3 on the remote Oracle8i database server. This is a very huge database
(around 17 million records or so) needs to be transferred to the remote
server. We are in planning process. The actual data is not ready to do so.
Therefore, I don't know how often the data needs to be transferred. We are
on the process to buy a new server with dual processors to store this huge
dat! ! a. And, we also wanted to go with Oracle9i EE while our client is
currently using Oracle8i. For this reason, programming languages and tools
to be used for development must be supported by and compatible with Oracle
version 8.1.7. Hope it answers your questions.
Thanks for your response. I do appreciate it.
Have a good weekend.
Lenka.
DENNIS WILLIAMS wrote:
Lenka - Perhaps you can explain your requirements in a little more detail.
Here are some questions that occur to me:
- What do you mean by "clone" specifically. Do you mean you have some
data in one or more tables you wish to move? Are you thinking you can move
datafiles themselves? Have you investigated transportable tablespaces?
- How much data is involved? A few gigabytes? A few megabytes? The
solutions vary dramatically by size. If it is just a little data, just
export and import the data.
- How often do you need to move this data? Only once? D! ! aily? Hourly?
I'm tired and going home for the weekend, but with more specifics you may
receive some responses during the weekend.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Friday, August 16, 2002 12:44 PM
To: Multiple recipients o! ! f list ORACLE-L
site
Hi All,
Anyone please direct me where I can find good resources about how to clone a
local database from Oracle9i server to a remote Oracle8i server site. Your
help is greatly appreciated.
Thanks in advance.
Lenka
_____
Do You Yahoo!?
HotJobs,
a Yahoo! service - Search Thousands of New Jobs
--
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 / Maili! ! ng 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 b! ! e removed from). You may
also send the HELP command for other information (like subscribing).
_____
Do You Yahoo!?
Yahoo!
Finance - Get real-time stock quotes
--
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 sp! ! elling 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).
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
