how to merge 2 tables from 2 different database?
Posted by:
irmtfan
Date: May 19, 2006 02:06PM
i have a running db and a backup. recetly i lost some of my data in my running site and want to back them from my backup.
in all 2 databes i have the same table. eg:
bb_posts ----> have these fields:
post_id pid topic_id forum_id post_time uid poster_name poster_ip subject dohtml dosmiley doxcode dobr doimage icon attachsig approved post_karma attachment require_reply
so i want 2 merge these 2 table in another new table ( or the same in my running site)
is this possible?
Subject
Views
Written By
Posted
how to merge 2 tables from 2 different database?
27589
May 19, 2006 02:06PM
14478
May 22, 2006 03:56AM
12044
June 01, 2006 11:16AM
11983
June 02, 2006 09:32AM
10981
June 02, 2006 10:10AM
10365
June 06, 2006 10:54AM
13917
August 28, 2006 04:10PM
9953
August 30, 2006 10:11AM
14692
September 05, 2006 01:35AM
8703
June 10, 2007 10:05AM
9147
June 21, 2007 01:54AM
8609
June 27, 2007 06:03PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.