oracle migration using export/import
Posted on 2009-05-04
I was doing export/import --- from 816 to 10202
i took the dump of the 816 database:
i installed the 10202 database.
1.. As a DBA user, perform a full export from the source database, for example:
> exp system/manager FULL=y FILE=myfullexp.dmp
3. Move the dump file to the target database server by scp
4. Create a database on the target server. -- create database [database name]
i have also run 6. Run catalog and catproc
5. Before importing the dump file, you must first create your tablespaces -- i did not create tablespace because the filesystem is same.
6. As a DBA user, perform a full import with the IGNORE parameter enabled:
> imp system/manager FULL=y IGNORE=y FILE=myfullexp.dmp
Using IGNORE=y instructs Oracle to ignore any creation errors during the import and permit the import to complete.
-- i got so many errors -- am i wrong at any step ?