Home » RDBMS Server » Server Administration » data transfer from production db to reporting
data transfer from production db to reporting [message #237400] Mon, 14 May 2007 06:42 Go to next message
fozerol
Messages: 17
Registered: March 2007
Junior Member
i have to transfer data from production to reporting
all table structures at the production and reporting are same
i have to transfer updated and inserted records, deleted record must be exist at the reporting db.
what is the simplest way to do that. i can do it with merge statement but is there another simple way to do that.
(transfer script will run every 24 hours)
i hope i could explain my problem well
Oracle version: oracle 10g R2 standard Edition
thanks for your replies

sample

production db reporting (before transfer) reporting (after trans. it has to be)
table X a1 is PK table X a1 is PK table X a1 is PK
a1 | b1 | c1 | d1 (column names) a1 | b1 | c1 | d1 (column names) a1 | b1 | c1 | d1 (clmn. names)
aa | bb | cc | 11 (deleted) aa | bb | cc | 11 aa | bb | cc | 11
dd | ee | ff | 22 (changed record) dd | ee | gg | 66 (before changed) dd | ee | ff | 22 (chged record)
gg | hh | ii | 33 (new record) gg | hh | ii | 33 (new record)
Re: data transfer from production db to reporting [message #237402 is a reply to message #237400] Mon, 14 May 2007 06:52 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Merge is the simplest way.
Otherwise you can also use Streams but it is a bit trickier.

Regards
Michel
Previous Topic: Oracle 10g New Features (including Release 2)
Next Topic: sqlload sqlldr
Goto Forum:
  


Current Time: Sun Dec 04 18:54:26 CST 2016

Total time taken to generate the page: 0.05266 seconds