Home » RDBMS Server » Backup & Recovery » Please give me idea now I compile all branch data in head office only new record and modify record
Please give me idea now I compile all branch data in head office only new record and modify record [message #188578] Sun, 20 August 2006 01:17 Go to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member
Hi master
Sir I have 5 office In different city and one head office in Karachi all branch have same oracle system my question is how I get new data and compile for accumulative reporting

I want only new record and modify record not old record
Old record already I import

When I use oracle import and export tool that no give me right result
If xxx table exists in database then import tool not replace and no insert or no replace with previous data with new modify data

Such as
First time
V_no=897 have debit amount 3998 is Islamabad branch and i export form Islamabad and import in Karachi office

Next time
Islamabad office change v_no=897 debit amount with 76555 and add many new record
I export form Islamabad and import in Karachi office but system no change and not add new record in Karachi office

Please give me idea now I compile all branch data in head office only new record and modify record

Thanks

aamir



Re: Please give me idea now I compile all branch data in head office only new record and modify reco [message #189626 is a reply to message #188578] Fri, 25 August 2006 05:33 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
Amir We are not able to understand your requirement...
See don't take it negative. Laughing

Your Question is.... Sir I have 5 office In different city and one head office in Karachi all branch have same oracle system my question is how I get new data and compile for accumulative reporting ?

I Can say this you can Achive by creating DB Link between all the Database.

Cheers..! Cool

[Updated on: Fri, 25 August 2006 05:33]

Report message to a moderator

Previous Topic: full backup
Next Topic: RMAN and RAC
Goto Forum:
  


Current Time: Tue Dec 06 10:21:34 CST 2016

Total time taken to generate the page: 0.09191 seconds