Database migration problems?

Author:Mikesj Time:02-08-27 19: 12

Database migration problems?

1. When porting a database, exp database a now needs imp data to another database B?
2. After database B is created, should the user and tablespace be consistent with the structure in database ?. If the user and tablespace names are inconsistent in A and B, how can this problem be solved?
3. If B does not need to create a user or table space: Ask exp full A, the content of the system table space should also be exported. IMP is sent to database B, if database B does not have the same disk structure as database A, for example, data files in database a are distributed on three disks, and data files in database B are distributed on two disks, does the system tablespace need to be changed after being imported as B?
4. If B needs to create a user and table space: How is the data exported by a and the system data in B processed ??
Thank you !!

Author:Snowhite2000 Time:02-08-28

Re: database migration problem?

1. When porting a database, exp database a now needs imp data to another database B?
EXP/imp is not the only way to migrate your database. If you new DB will under same platform, you can just copy the database to new server and run one scripte.

2. After database B is created, should the user and tablespace be consistent with the structure in database ?. If the user and tablespace names are inconsistent in A and B, how can this problem be solved?

If you want to import all export database, you do not need create tablespace. Import processes will create that for you, but you need add some parameter to you import string.

If you users and tablespaces are different in two database, you can manually import using import user mode. In this way, you have to import user schema one by one.

3. If B does not need to create a user or table space: Ask exp full A, the content of the system table space should also be exported. IMP is sent to database B, if database B does not have the same disk structure as database A, for example, data files in database a are distributed on three disks, and data files in database B are distributed on two disks, does the system tablespace need to be changed after being imported as B?

You don't need care about this, Oracle will do that for you.

4. If B needs to create a user and table space: How is the data exported by a and the system data in B processed ??

How to import your data, that is really up to your situation.
You can import everything to the new database first, than arrange it. You also can just import those data you need for new database, and get rid of those garbage data.

Make your migration plan first, then ask if Oracle can do that for you or not.

Snowhite2000