Replicating Oracle DB from Unix to NT through Exp/Imp

[HenryMonster]

Hi All,

Can somebody help me with the following:

We are running Siebel CRM system with Oracle 8.1.6
as the database.

Our production database server is Sun/Solaris.

We have a development environment where Oracle DB
(same version) runs on Win NT server.

I have a full production export.

How can I completely refresh my development
database from this full export ?


Thank you in advance !

 

[rcurva]

This is not actually a refresh, but more of a rebuild of a database using your full export to the NT machine. Its either you do this or do an import by user (drop first the users in your NT server).

Steps:
1. Create a database on the target server. Create all the tablespaces in your
NT machine similar in size to the one in Unix. The datafiles, of course
are different.

2. Before performing the import, you will need to precreate your tablespaces.
This is necessary since the import will want to create the corresponding
datafiles in the same file structure as was at the source database. Since
your file structure will be different on the target database, precreating
the tablespaces will allow you to specify a file structure that will work.

3. Perform a full import with the parameter IGNORE=Y into the target database
as a DBA user.

imp system/manager full=y ignore=y file=expdat.dmp

Using IGNORE=Y will tell Oracle to ignore any creation errors during the
import, allowing the import to complete.

Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War