| Need Help In Replication. [message #117062] |
Sun, 24 April 2005 03:48  |
sohailnawaz
Messages: 40
Registered: April 2005
Location: Saudi Arabia
|
Member |
|
|
SIR,
I WANT TO REPLICATE THE VALUES IN THE TABLE OF ANOTHER SCHAMA. MEANS ONE TABLE IN THE SCHEMA A AND OTHER TABLE IN THE SCHEMA B. NOW I WANT TO REPLICATE THE VALUES FROM SCHAMA A TO SCHEMA B. HOW CAN I DO THAT.
THANKS IN ADVANCE.
THANKS
SOHAIL NAWAZ
|
|
|
|
| Re: Need Help In Replication. [message #117142 is a reply to message #117062] |
Mon, 25 April 2005 07:23  |
rucknrun
Messages: 26
Registered: April 2005
Location: Edgewood, MD
|
Junior Member |
|
|
I would create a materialized view of the table in the 1st schema in the 2nd if you need to refresh the table on a regular basis. If you only need to do it once you can just:
create table <Table_NameB> as select * from <Table_NameA>;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
