Expdp/impdp for data migration from Oracle10g to 11g

Expdpimpdp Oracle10g to 11g data migration, the import will prompt a ORA-31684: ObjecttypeUSER: XXXalreadyexists. This does not matter.

Expdp/impdp for Oracle 10g to 11g data migration, the import will prompt a ORA-31684: Object type USER: XXX already exists. This does not matter.

Original database version: Oracle 10.2.0.4.0

Target database version: Oracle 11.2.0.1.0

Use expdp to export data from the original database:

Expdp system/xxxxxx schemas = test1201 directory = easbak dumpfile = test1201.dmp logfile = zytest1201.log;

Preparations before impdp:

1: ensure that the character set of the target database is consistent with that of the original database.

2: after creating the required tablespace, You can query the table space query statement test1201 in the original database as follows:

Select distinct tablespace_name from dba_segments where owner = 'test1201 ';

After creating the tablespace, the temporary tablespace does not need to be created.

Create tablespace EAS_D_TEST1201_STANDARD datafile '/u01/app/oracle/oradata/orcl/eas_d_test1201_standard.dbf' size 8000 m autoextend on next 100 m maxsize unlimited autoallocate;

Create tablespace EAS_D_TEST1201_TEMP2 datafile '/u01/app/oracle/oradata/orcl/EAS_D_TEST1201_TEMP2.dbf 'size 800 m autoextend on next 10 m maxsize unlimited autoallocate;

3: after creating a tablespace, you need to create a user and authorize the user. The permissions are consistent with those of the original database user.

Create a user:

Create user test1201 identified by kingdee default tablespace EAS_D_TEST1201_STANDARD quota unlimited on EAS_D_TEST1201_STANDARD quota unlimited on EAS_D_TEST1201_TEMP2;

Query the permissions of the original database user:

Select * from dba_sys_privs where grantee = 'test1201 ';

Then, authorize the user:

Grant create view, create sequence, unlimited tablespace, select any dictionary, create procedure, create table, create trigger, create materialized view, create session to test1201;

4: create a directory and grant the read/write permission to the user:

Create or replace directory orabak as '/u01/app/orabak ';

Grant write, read on directory orabak to test1201;

After the preceding four points are completed, the data will be imported:

Copy the exported file to the orabak directory and import it.

Impdp system/xxxxxx schemas = test1201 dumpfile = test1201.dmp logfile = expdp_test11.log directory = orabak table_exists_action = replace job_name = my_job6;

When the import will prompt a ORA-31684: Object type USER: "XXX" already exists. This does not matter. then check whether there are other errors in the log, if not, it will succeed.