Thanks Paul and Scott..for the responses !
well we use Oracle database. The purpose of synchronizing all databases is - after 4 years of our application, some data available in test databases are not in use and new updates are happening in prod database. And we are the admins of our application and yes we have full access for production. Main reason for availing this facility to us is just to reduce our efforts in synchronising the databases. Beacuse it is us, who update the prod database along with other normal users too.
Please suggest me any solution to synchronize other test databases according to prod data and NOT VICE VERSA.
One solution is creating datalink and copying prod data in stage database. But that is very time consuming process and do copying one by one table not all at one time
Thanks,
Manisha