Thank you for the information.
I am still having some problems. Will give you the details again - maybe I missed something the first time.
I have 2 databases.
DB1 & DB2.
There is data that is going once a week into DB1. This data i have to capture and populate a table (table 'A') in DB2.
Once table 'A' is populated I need to store the old data into tables in DB2. For example:
given_name in table'A' used to be 'y', but after the update is now'x'. I have to take 'y' and put it into another table so that it is stored and accessible if needed.
What I have so far done:
I have a dblink between DB1 and DB2.
I have a temp table called 'B' that has the fields from the six tables in DB1 that I want to take the data from.
I do not know how to extract ONLY the data I need so that I can populate table 'B' in DB1(my temp table).
CLIENT_ID NOT NULL VARCHAR2(9)
DATE_OF_BIRTH NOT NULL DATE
SEX NOT NULL VARCHAR2(1)
REGION_CODE NOT NULL VARCHAR2(2)
CLIENT_TYPE NOT NULL VARCHAR2(1)
INSERT_DATE NOT NULL VARCHAR2(14)
Out of the above table I only need to get client_id, sex,region_code,province,client_type, api,pilot_id.
I have five more tables similar to the one above that I need to do the same thing with.
If I get pass this problem then the only other one is once my temp table ('B') is populated how do I transfer the data from table 'B' over to table'A'. Keep in mind 'A' is in DB2 and 'B' is in DB1.
I trully hope you can assist me in completing my task.
Once again thank you very much for you time.
I hope I understand your pb correctly :
insert into A
select client_id, sex,region_code,province,client_type, api,pilot_id
Click Here to Expand Forum to Full Width