Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I trying to copy entire data from old database to newly created database in oracle 10g. please any one tell me the steps to do the process.

share|improve this question

migrated from Jul 26 '12 at 11:03

This question came from our site for professional and enthusiast programmers.

IMO this belongs on SuperUser or ServerFault, not on StackOverflow. – Jonathon Reinhart Jul 26 '12 at 5:43
Which product & version is your old database? – GWu Jul 26 '12 at 6:22
You might want to look into Oracle export and import (and latterly data pump). See: – Ollie Jul 26 '12 at 9:10
Do you have or are you using SQL Developer? It has a "Data Pump Wizard" which could be a very easy way to get this done. See… for a step-by-step guide. – Colin 't Hart Jul 26 '12 at 12:06

One way would be to user RMAN's Duplicate Database feature.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.