Oracle标准版不支持并行
👉 本文共约149个字，系统预计阅读时间或需1分钟。
现象
1 2 3 4 5 6 7 8 9 10 11 | d:\>impdp system/"lhr"@127.0.0.1/jde DIRECTORY=DATA_PUMP_DIR FULL=Y LOGFILE=impdp_20220610.log network_link=dbl_12c EXCLUDE=STATISTICS PARALLEL=12 Import: Release 19.0.0.0.0 - Production on Fri Jun 10 11:28:41 2022 Version 19.15.0.0.0 Copyright (c) 1982, 2022, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production ORA-39002: invalid operation ORA-39094: Parallel execution not supported in this database edition. |
版本查询
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | C:\Users\lhrxxt>oerr ora 39094 39094, 00000, "Parallel execution not supported in this database edition." // *Cause: Parallel execution of Data Pump jobs is not supported for this // database edition. // *Action: Specify a parallelism of 1 for jobs not running on Enterprise // Edition databases. C:\Users\lhrxxt>sqlplus system/lhr@10.4.1.218/jde92 as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 10 12:31:31 2022 Version 19.15.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. Connected to: Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Version 19.15.0.0.0 SQL> set line 10000 SQL> select * from v$version; BANNER BANNER_FULL BANNER_LEGACY CON_ID -------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production 0 Version 19.15.0.0.0 SQL> |
解决
去掉参数PARALLEL=12即可正常导入。
若版本不是标准版
若版本不是标准版，但依然报错，那么可以尝试执行如下脚本：@$ORACLE_HOME/rdbms/admin/dpload.sql;
