Is it possible to recreate or import a database by just moving the datafiles from one database to the other? Can...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
you outline the procedure of how it can be done? I know this can be done in Oracle 8.1.6, but is it possible in previous versions like 8.0.5?
It is possible (at least for Oracle 7+) to accomplish this with a few caveats. One, the origin server and destination server must have the same operating system and block size. Two, unless you really want to confuse the issue, try moving the entire database. After the database is moved to the destination server, then you can get rid of what you did not want to move. Regardless of the database version, try this method:
- Dump the control file to trace
ALTER DATABASE BACKUP CONTROL FILE TO TRACE;
- Shutdown the database
- Transfer the files to your destination server.
If you are using FTP, make sure you use the Binary mode.
Transfer all of the files including your controlfile dump, your data files, your init.ora file and your password file.
- Place the datafiles in their new directories.
- Modify the controlfile dump with the new directories so that the database can find the datafiles.
- Startup the database in NOMOUNT mode.
- Run the controlfile dump to recreate the control files.
- Open the database
ALTER DATABASE OPEN;
That's basically it!
For More Information
- What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle tip to offer your fellow DBA's and developers? The best tips submitted will receive a cool prize--submit your tip today!
- Ask your technical Oracle questions--or help out your peers by answering them--in our live discussion forums.
- Ask the Experts yourself: Our Oracle guru is waiting to answer your toughest questions.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.