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: 86
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.

Report message to a moderator

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: 8960
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.

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 28 21:40:09 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.