Re: How to transfer Oracle Database to another Oracle Distributed Database ?

From: Capt. Confusion <dazed_at_confused.com>
Date: Tue, 10 Jun 2003 04:21:04 GMT
Message-ID: <Q0dFa.2434$5n1.125777059@newssvr21.news.prodigy.com>

"SouthVN" <nphuongtt_at_yahoo.com> wrote in message news:ee28214c.0306092009.90949a8_at_posting.google.com...
> Hans Forbrich <forbrich_at_telusplanet.net> wrote in message
news:<3EE3DF54.90F8982_at_telusplanet.net>...
> > Please expand the problem statement. Your question does not contain
enough
> > information & there are too many possible solutions. At the least,
consider
> > answering the following questions:
> >
> > A) What are you trying to accomplish?
> >
> > For example - should this happen once only? Is it ongoing transfer? Is
it
> > synchronization? Why do you want to do the transfer? When you say
> > 'Distributed' database - is it on the same network? is it always
available
> > or sometimes disconnected (as in laptop)?
> >
> > B) What operating system or systems? Which versions of the operating
> > systems?
> >
> > C) Which version of the database(s) right now? (When you say Oracle9i,
> > there are two major 9i releases and many patch levels, please be as
specific
> > as possible.)
> >
> > D) What have you already reviewed? What have you tried or are
interested in
> > trying? What have you rejected?
> >
> >
> >
> > SouthVN wrote:
> >
> > > How to transfer Oracle Database to another Oracle Distributed Database
?
> > > And Which tool of Oracle 9i ?
> > >
> > > Anybody know, please help me !
> > >
> > > Thanks

>

> Thanks Hans Forbrich alot !!! :)

>

> I don't know about Oracle, and Distributed Database. But
> I had received a project from my Boss that database was Oracle 8.15.
> And now difficult problem is database was too large (table Cusotmer:
> more 700000 reccords ), so customers'll access into website to get
> their information very slow.

>

> So, We must transfer database 8i (from another project) to 9i(for my
> project) and database for my project must be Distributed Database to
> reduce access of Customer

>

> Now, I don't know clearly about Oracle, I'm research them, and time
> for my project is only 2 weeks

>

> My role is write one module to transfer Oracle 8i database (had export
> to harddisk) and I use that database to import into my Oracle 9i
> distributed database. Now I don't know how...

>

> My operating system is Window 2000 Advance

>

> Thanks you very much !

>

> SouthVN

>
> PS: My English is bad, Please forgive me !

If I were in your situation (only 2 weeks), I would use an updateable snapshot (if your going to allow the customer to change their information). If you're not going to allow the customer to change their information, then a materialized view would suffice. But if you are going to allow changes to multiple database tables based on geography, then a combination of partitioning and asynchronous replication is the best solution in my opinion. But with only two weeks, I'm afraid for you that you may have to compromise your solution. Be prepared for massive fallout. Received on Mon Jun 09 2003 - 23:21:04 CDT