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
1

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

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

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

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.