View Single Post

  #2 (permalink)  
Old 02-11-2008, 05:32 PM
siri6589 siri6589 is offline
Junior Member
 
Join Date: Jan 2007
Posts: 5
siri6589 is on a distinguished road
well the general steps are as follows....
1)export the production schemas
2)backup test/dev schemas before refreshing
3)extract the ddl to creat the schema user
4)drop the schema user in test/dev
5)import schema from production

Well I know this soultion. If any one has better one please do post.

Thanks,
Naveen
Reply With Quote