i have an oracle instance running . I want the same database datas into another database in different machine. Can anyone suggest what is the easiest way to acheive this? Is it what we call database replication?
What are your needs ??? Sometimes multimaster replication is the answer
if you are going to have people sharing data on separate databases, other
times, snapshots is the answer, especially if you only want a segment of
the data shared (ie, employee table ... only share the employee's in dept 20)
If it's for a "failover" situation, then you might want to look at other options..