Deepak -- Thanks for the question regarding "Inserting data directly from 9i to 10g", version 9.2.0.1.0

Submitted on 1-May-2008 1:34 Central time zone

Tom's latest followup | Bookmark | Bottom

Last updated 2-May-2008 7:31

You Asked

Pl suggest me if i can insert the data directly from one database which is 9i to another database which is for Oracle Apps running on 10g. The 2 database are running on different machine , 9i on Win2k and 10g on Linex rel 5.

and we said...

You may use database links for this, of course.

The database has for as long as I've worked at Oracle supported distributed transactions...

Create a database link and you can do this rather easily.

Now that said, I would not make it part of my application - an end user driven application should not rely on database links as it makes you a tightly coupled system (both systems have to be up for the application to work). You want to use database links in background processes - batch processes.

Reviews

Another option... May 1, 2008 - 11am Central time zone

Bookmark | Bottom | Top

Reviewer: Daniel from Toronto

That scenario might also be implemented with advanced replication from one site to another, with 
refreshes scheduled at convenient times and intervals.

Followup May 1, 2008 - 11am Central time zone:

ummm, what scenario - they gave NO scenario.

I hate replication...

replication May 1, 2008 - 5pm Central time zone

Bookmark | Bottom | Top

Reviewer: Radoslav Golian

>> I hate replication... 

Why do you hate it? 
I'm just curious :).

Followup May 1, 2008 - 9pm Central time zone:

why do it

it adds complexity

it is almost always implemented wrong (what, we needed to have update conflict resolution routines, we needed to design for that, we needed to think about this - it should just happen)

it is almost always not needed - one case I can think where it is - on a submarine. In the year 2008, replication should die a quick death.

distributed is distributed complexity. It is not easy, it takes LOTS of resources. It takes a ton of planning. It take a lot of design.

and people do not do that.

Will PX work across the DB link from 9i to 10G? May 2, 2008 - 6am Central time zone

Bookmark | Bottom | Top

Reviewer: Naresh Bhandare from Cyprus

hi Tom,

Will Parallel execution work across a DB link from 9i to 10G? (It would be useful for copying large 
tables as a one time operation for data migrations).

It does work from 9i to 9i.

Thanks,
Naresh

Followup May 2, 2008 - 7am Central time zone:

it'll will serialize over the dblink

you can run a parallel query on the remote site, you can run a parallel insert on the local site, however the data will traverse one pipe over the network. (even in 9i, meaning, I see it being of limited benefit in almost all cases - with the exception of a remote parallel query when you are joining or aggregating)

Inserting data directly from 9i to 10g", version 9.2.0.1.0 May 5, 2008 - 2am Central time zone

Bookmark | Bottom | Top

Reviewer: Deepak Singh from Dubai, UAE

Thnx tom,
As suggested i'm gonna change the design & make nessesary amendments to make 2 systems work 
independently.

Write a Review