Problems with migrating from 8.1.7 (Linux) to 8.1.7 (w2k)

Hi,

I'm currently in a process were I have to move a database from 8.1.7 on UNIX to an 8.1.7 on w2k. I have done some tests with imp/exp but I'm not sure that imp/exp is sufficient for this migration because of the database structure. The database structure is as following:

4 tablespaces, 1 for data, 1 for index, 1 for rollback segments and 1 for temp. On the rollback tablespace there is created 12 rollback segments. further more the application that runs on this database use intermedia (heavily).

I have tried to do an imp/exp, but I'm not completely sure that every thing is fine (one of my jobs is failing, and I can't get it working).

my exp statement look like this:
* export NLS_LANG=American_America.WE8ISO8859P1

• exp user_at_SID file=/xxx/xxx/xxxx-17012003.dmp grants=y indexes=y rows=y constraints=y owner=xxx triggers=n

I get my .dmp file and doing an imp like this:
* set NLS_LANG=American_America.WE8ISO8859P1

• imp user_at_SID file=XXXXX grants=y indexes=y rows=y constraints=y full=y

When the import is done, I have to rebuild some of my intermedia indexes because they are broken and I create all my triggers.

The broken indexes and jobs that is not able to run makes me a bit nervous about the migration is not complete.

Anybody got suggestions how to do the migration to make sure that every thing is correct?? or another way to migrate other than using imp/exp???

Regards

TJ Received on Wed Jan 29 2003 - 06:37:32 CST