oracle数据导入
1、dmp文件放在 /u01/app/oracle/xnyxn 目录下
2、进入 /u01/app/oracle/ 将文件权限赋予oracle
chown -R oracle:oinstall ./xnyxn
chmod -R 777 ./xnyxn
3、切换到oracle用户
su - oracle
4、执行导入语句，（先用xny_policyresearch验证一下，外网的xny_common暂时不用导入）
impdp xny_manufacturer/xny19jkl39sg@PDBXNYO DUMPFILE=xny_manufacturer.DMP DIRECTORY=DATA_XNY_XL logfile=xny_manufarer.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_manufacturer
impdp xny_load/xny19jkl39sg@PDBXNYO DUMPFILE=xny_load.DMP DIRECTORY=DATA_XNY_XL logfile=xny_load0622.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_load
impdp xny_newtechnology/xny19jkl39sg@PDBXNYO DUMPFILE=xny_newtechnology.DMP DIRECTORY=DATA_XNY_XL logfile=xny_newtechnology5.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_newtechnology
impdp xny_planningplan/xny19jkl39sg@PDBXNYO DUMPFILE=xny_planningplan.DMP DIRECTORY=DATA_XNY_XL logfile=xny_planningplan.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_planningplan
impdp xny_powerusers/xny19jkl39sg@PDBXNYO DUMPFILE=xny_powerusers.DMP DIRECTORY=DATA_XNY_XL logfile=xny_powerusers.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_powerusers
--impdp xny_common/xny19jkl39sg@PDBXNYO DUMPFILE=xny_common.DMP DIRECTORY=DATA_XNY_XL logfile=xny_common1.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_common
impdp xny_splydemand/xny19jkl39sg@PDBXNYO DUMPFILE=xny_splydemand.DMP DIRECTORY=DATA_XNY_XL logfile=xny_splydemand.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_splydemand
impdp xny_gis/xny19jkl39sg@PDBXNYO DUMPFILE=xny_gis.DMP DIRECTORY=DATA_XNY_XL logfile=xny_gis.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_gis
impdp xny_tariffsubsidy/xny19jkl39sg@PDBXNYO DUMPFILE=xny_tariffsubsidy.DMP DIRECTORY=DATA_XNY_XL logfile=xny_tariffsubsidy.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_tariffsubsidy
impdp xny_bigdata/xny19jkl39sg@PDBXNYO DUMPFILE=xny_bigdata.DMP DIRECTORY=DATA_XNY_XL logfile=xny_bigdata.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_bigdata
impdp xny_assistmakepolicy/xny19jkl39sg@PDBXNYO DUMPFILE=xny_assistmakepolicy.DMP DIRECTORY=DATA_XNY_XL logfile=xny_assistmakepolicy.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_assistmakepolicy
impdp xny_resources/xny19jkl39sg@PDBXNYO DUMPFILE=xny_resources.DMP DIRECTORY=DATA_XNY_XL logfile=xny_resources.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_resources
impdp xny_statistics/xny19jkl39sg@PDBXNYO DUMPFILE=xny_statistics.DMP DIRECTORY=DATA_XNY_XL logfile=xny_statistics.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_statistics
impdp xny_environment/xny19jkl39sg@PDBXNYO DUMPFILE=xny_environment.DMP DIRECTORY=DATA_XNY_XL logfile=xny_environment.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_environment
impdp xny_intracompany/xny19jkl39sg@PDBXNYO DUMPFILE=xny_intracompany.DMP DIRECTORY=DATA_XNY_XL logfile=xny_intracompany.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_intracompany
impdp xny_policyresearch/xny19jkl39sg@PDBXNYO DUMPFILE=xny_policyresearch.DMP DIRECTORY=DATA_XNY_XL logfile=xny_policyresearch.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_policyresearch
impdp xny_absorptive/xny19jkl39sg@PDBXNYO DUMPFILE=xny_absorptive.DMP DIRECTORY=DATA_XNY_XL logfile=xny_absorptive01.log TABLE_EXISTS_ACTION=REPLACE schemas=xny_absorptive
出现错误ORA-39346: data loss in character set conversion for object COMMENT:"XNY_SPLYDEMAND"."XNY_SPLYDEMAND_PRD_LARGEENERGY"
不用管，正常
5、验证，sqlplus连接后并更换session。或者直接查看log日志验证导入
5.1 su - oracle
5.2 sqlplus /nolog
5.3 conn / as sysdba
5.4 alter session set container = PDBXNYO;
5.5 conn xny_intracompany/xny19jkl39sg@10.3.76.19:11521/PDBXNYO
