免费做自己的网站,石家庄定制网站建设多少钱,淘宝店铺去哪里买,阜蒙县建设镇网站由于工作需要#xff0c;有时候需要将oracle18c的数据同步到另一个环境的10g版本 测试环境 #xff1a;
源数据库版本#xff1a;18.13.0.0
目标数据库版本#xff1a;10.2.0.4
结论#xff1a;
1 从低版本导出#xff0c;导入到高版本#xff0c;可以#xff0c;不…由于工作需要有时候需要将oracle18c的数据同步到另一个环境的10g版本 测试环境
源数据库版本18.13.0.0
目标数据库版本10.2.0.4
结论
1 从低版本导出导入到高版本可以不需要加参数version
2 从高版本导出导入到低版本不可以。需要在导出的时候加上version参数。在导入的时候加参数version无效。
源数据库
[oracledp]$ expdp l5m/l5m directoryDPPATH schemasTTT fileTTT.dmp version10.2.0.4Export: Release 18.0.0.0.0 - Production on Fri Jun 14 10:25:21 2024
Version 18.13.0.0.0Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: fileTTT.dmp Location: Command Line, Replaced with: dumpfileTTT.dmp
Legacy Mode has set reuse_dumpfilestrue parameter.Warning: Oracle Data Pump is exporting from a database that supports long identifiers to a version that does not support long identifiers.Starting L5M.SYS_EXPORT_SCHEMA_03: l5m/******** directoryDPPATH schemasTTT dumpfileTTT.dmp version10.2.0.4 reuse_dumpfilestrue
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . exported TTT.T1 72.79 KB 428 rows
Master table L5M.SYS_EXPORT_SCHEMA_03 successfully loaded/unloaded
******************************************************************************
Dump file set for L5M.SYS_EXPORT_SCHEMA_03 is:/u01/dump/dp/data/TTT.dmp
Job L5M.SYS_EXPORT_SCHEMA_03 successfully completed at Fri Jun 14 10:27:29 2024 elapsed 0 00:02:07
导出之后将文件传到目录服务器直接通过imdp就可以了不需要加version参数。
[oracledata]$ impdp l5m/l5m dumpfileTTT.dmp directorydumppahtImport: Release 10.2.0.4.0 - 64bit Production on Thursday, 13 June, 2024 22:41:42Copyright (c) 2003, 2007, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name DUMPPAHT is invalid[oraclel5mDev121 data]$ impdp l5m/l5m dumpfileTTT.dmp directorydumppathImport: Release 10.2.0.4.0 - 64bit Production on Thursday, 13 June, 2024 22:41:50Copyright (c) 2003, 2007, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table L5M.SYS_IMPORT_FULL_01 successfully loaded/unloaded
Starting L5M.SYS_IMPORT_FULL_01: l5m/******** dumpfileTTT.dmp directorydumppath
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported TTT.T1 72.79 KB 428 rows
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job L5M.SYS_IMPORT_FULL_01 successfully completed at 22:41:53如何从高版本数据库导出dmp至低版本数据库导入 - 墨天轮
https://www.oracle.com/a/ocom/docs/oracle-data-pump-best-practices.pdf
Export/Import DataPump Parameter VERSION - Compatibility of Data Pump Between Different Oracle Versions (Doc ID 553337.1) - 晟数学苑 - 学习塑造未来
