Unanswered: transferring .dbf file from development to production box
For some reason, I am having a problem with starting up oracle on my development box. So as a temporary solution, I wanted to transfer the .dbf file and tablespace from the development box to a new temporary "development" user under the production database. However, I am not sure of how to do this correctly since the .dbf files are dependent on control files.
What is the best way to do this in a way where the development dbf file (which has the same schema as the production database) will not interfere with the production schema?