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 am trying to clone a schema from one Oracle 10g server to a different Oracle 10g server.

I have created a database template (DBCA) from an existing database (structure and data).

I have copied the three template files .dbc, .DBF and .CTL to the other oracle 10g server. Do I need to copy any other files?

I am looking to achieve this by using DBCA utility not through the import/export data pump.

I can clone a database on the same machine using DBCA utility but am not able to clone it on the different machine using the first machine's template.

share|improve this question

migrated from Sep 24 '12 at 19:42

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

I am looking to achieve this by using DBCA utility not through import/export data pump. – Hanah George Sep 27 '12 at 8:40
Just get the pfile from the other database, edit proper paths. Create a spfile from the pfile ( ) – Munchi Sep 27 '12 at 11:17

Your Answer


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

Browse other questions tagged or ask your own question.