Oracle-L: RE: How to clone a local database from 9i server to a remote 8i s

From: Meomeo Nguyen <meomeo22_at_YAHOO.COM>
Date: Fri, 16 Aug 2002 16:13:18 -0800
Message-ID: <F001.004B816F.20020816161318@fatcity.com>

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 of 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

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).

Do You Yahoo!?
HotJobs, a Yahoo! service - Search Thousands of New Jobs
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Meomeo Nguyen
INET: meomeo22_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------