Home » RDBMS Server » Backup & Recovery » Need Help In Replication.
Need Help In Replication. [message #117062] Sun, 24 April 2005 03:48 Go to next message
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 Go to previous message
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>;
Previous Topic: Restoring from RMAN backup nocatalog to a new machine
Next Topic: Running RMAN using 8.1.7.4
Goto Forum:
  


Current Time: Fri Mar 29 03:42:08 CDT 2024