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

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

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.