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 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
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 ( dba-oracle.com/concepts/pfile_spfile.htm ) –  Munchi Sep 27 '12 at 11:17
add comment

migrated from stackoverflow.com Sep 24 '12 at 19:42

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

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.