Home » RDBMS Server » Server Administration » Hi folks, We have a production database on RAC Mode which has 4 node setup , we need to refresh (Oracle DB 11.2.0.3.0, Red hat linux enterprise edition 6.4)
Hi folks, We have a production database on RAC Mode which has 4 node setup , we need to refresh [message #608021] Fri, 14 February 2014 06:15 Go to next message
oradba123
Messages: 78
Registered: June 2009
Location: india
Member

Hi folks,

We have a production database on RAC Mode which has 4 node setup , we need to refresh two user or schema tables which around 200 tables from production to test database for examaple

Prod is Production database on 4 RAC node setup username are proddta, prodctl, both of them have around 200 tables i need to refresh test database with two users name testdta,testctl,
now my question is is there any way to refresh this through Enterprise Manager cloud control 12c or SQL developer or Toad?
please if so could you people tell me the way through snap shot or step by step prodecure

I would appreciate a lot for your suggestion


we don't have oracle user level access so there is no chance for Expdp/Impdp, or normal exp/imp


thanks & regards.
Re: Hi folks, We have a production database on RAC Mode which has 4 node setup , we need to refresh [message #608032 is a reply to message #608021] Fri, 14 February 2014 07:40 Go to previous message
John Watson
Messages: 4793
Registered: January 2010
Location: Global Village
Senior Member
I don't have a Cloud Control available to check at the moment, but I thought it includes a Data Pump interface.

Previous Topic: Provide Oracle 8i Software Download link
Next Topic: DB look like hang or spin, Only sys user can connect to DB but can't query anything
Goto Forum:
  


Current Time: Sat Nov 22 20:31:47 CST 2014

Total time taken to generate the page: 0.12304 seconds