Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 stackoverflow.com 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: docs.oracle.com/cd/B28359_01/server.111/b28300/expimp.htm –  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 oracle-base.com/articles/misc/… for a step-by-step guide. –  Colin 't Hart Jul 26 '12 at 12:06

1 Answer 1

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.