Need to refersh a test database from production

[siri6589]

Hi I am new to oracle DBA field. I need to refresh my test and development databases from production. Can any one suggest the best method and ways of doing it? All the 3 databases are on 10g. You help will be greatly apprecited.

Thanks a lot
siri6589

[siri6589]

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