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 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 <http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.92 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. [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 / 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 b! ! e removed from). You may also send the HELP command for other information (like subscribing). _____ Do You Yahoo!? Yahoo! <http://rd.yahoo.com/finance/mailsig/new/*http://finance.yahoo.com> 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 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).
