Tell me more ×
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.
up vote 1 down vote favorite

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
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

migrated from stackoverflow.com Jul 26 '12 at 11:03

1 Answer

up vote 2 down vote

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

share|improve this answer

Your Answer

 
discard

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