Copying a database to Windows 200x
I am a database operator with experience in IT industry/manufacturing for
more than nine years. We were using Oracle 7x then migrated to 8i; it has all
been done by our application provider. Now the time has come to learn to do
it myself. We have our applications running on NT4/Oracle 220.127.116.11.0. How
do I create a replica of the same database in 9i under Win200x?
I have all DBF/dmp ready. How do I start the process? What
all should I do to create databases in 9i, etc.?
The easiest way to move your database to Windows 2000/2003 is to
perform the following steps:
- Install Oracle 9i on your Windows 2000/2003 server.
- Use the DBCA to precreate a database on this server.
- Precreate any users and tablespaces you'll need in this new
- On the old database server, use Oracle's export utility to dump the
entire contents of the database:
exp userid=system file=mydb.dmp full=y
- Transfer the dump file to your new database server. If using the FTP
utility, make sure your FTP is in BINARY mode.
- Use the import utility to ingest the dump file contents:
imp userid=system file=mydb.dmp full=y
This was first published in August 2005