| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to clone a local database from 9i server to a remote 8i s
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 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.
dwilliams_at_lifetouch.com
-----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 your 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 data. 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? Daily? 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.
dwilliams_at_lifetouch.com
-----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: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
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: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
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: 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). Received on Tue Aug 27 2002 - 12:14:43 CDT
 |
 |