Oracle_11g table + perfect data migration to 10g solution

Oracle_11g table + perfect data migration to 10g solution 1. Use imp/exp to perfectly migrate 10g (Table + data) to 11g, everyone on Earth knows. GB (Table + Data) migration to 10 Gb is perfect. solution 1: on the 11 GB server, use the expdp command to back up data expdp userid = 'szairpay/szairpay @ orcl 'schemas = szairpay directory = DATA_PUMP_DIR dumpfile = sz11g. dmp logfile = sz11g. log version = 10.2.0.3.0 'szairpay/szairpay @ orcl account/password @ database instance schemas = szairpay can omit directory = data_pump_dir to put the directory of the generated file, generally, it is generated to admin \ orcl \ dpdumpdumpfile = sz11g. the file name generated by dmp is logfile = sz11g. log, version = 10.2.0.3.0. The value on the right of the parameter above the 10 Gb oracle version to be placed can be based on the actual situation. Step 2: Use the impdp command to restore data on a 10g server: 1. database creation 2. create a tablespace 3. create a user and authorize the user 4. set dag. copy dmp to the 10 Gb dpdump directory. import impdp to database 1. Create a database: directly create a database (instance) in database configuration assistant ). 2. create a tablespace: create tablespace szairpay datafile 'd: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ szairpay. dbf 'size 400 m autoextend on next 20 m online; note that the tablespace name must be consistent with the tablespace name in 11G. 3. create uszairpay oa identified by szairpay. Note, this username must be the same as the username in 11G. Authorize: Alter user szairpay default tablespace szairpay quota unlimited on szairpay; // you can change the OA by yourself. grant create session to szairpay at first glance; grant connect to szairpay; grant connect, resourc E, dba to szairpay; grant create table to szairpay; grant create view to szairpay; grant create trigger to szairpay; grant select any table to szairpay; grant create sequence to szairpay; grant create procedure to szairpay; grant create role to szairpay; grant create type to szairpay; grant grant any privilege to szairpay; 4. Import: first, 10 Gb of the test machine is installed in D: /Under the root directory, then the sz11g. dmp file copied to E: \ SETUP \ Oracle10g \ zhumulu \ admin \ orcl \ u Dump directory. Run the following command to create a directory: sqlplus sys/sys @ daggissql> create directory dump_dir as 'e: \ SETUP \ Oracle10g \ zhumulu \ admin \ orcl \ udump '; 5. Import Data impdp userid = 'szairpay/szairpay @ orcl as sysdb' schemas = szairpay directory = DATA_PUMP_DIR dumpfile = sz11g. dmp logfile = sz11g. log version = 10.2.0.3.0 so far, all the operations have been completed, and finally we have seen a long-overdue message: the operation is complete! Finally, we have a command to check the total number of users of the original object. You can perform verification as needed. Run the command once on the machine that exports the database and once on the machine that imports the database to see if the result is the same: SQL> select count (*) from dba_objects where owner in ('hangou', 'up', 'qishun'); Haha, the above is all the processes of my operations, if you have a better solution, please remember to share it! Everyone learns from each other and makes progress together!