| data transfer from production db to reporting [message #237400] |
Mon, 14 May 2007 06:42  |
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)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
