If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Move Oracle database to different platform

I am trying to move oracle database from HP (Oracle 9i) to Windows (Oracle 10G). I created database and tablespaces on Windows, copied the exported file on Windows machine, did the full database import. The result is 'Import terminated successfully with warnings'. There are lots of the error messages in the import log like below. Any idea?

Yes, the object counts in the target database have much more than source database. I was coping a database from one machine (9i) to another machine (10g) by doing the full database import, then recompiled the invalid objects after the import. Did I miss anything before/after import?

There are a lot different object counts in the new databse. What's the best way to move a database from Server A(9i) to Server B(10G) with database users and their schemas. Is there steps by using Full database import or Transportable tablespace? How to move the database users/password to another server?