oracle - 在连接浏览器中显示表格时如何修复 SQL Developer 中的 ORA-12801 错误

Question

使用 SQL Developer 18.4 MacOSX，我收到此错误

ORA-12801: 并行查询服务器 P000 中发出错误信号
ORA-01722: 无效号码

当我尝试在连接选项卡中显示表格列表时。

我已经隔离了查询。当我一个一个地执行“union all”的每个部分时，没有错误。当我执行所有查询时，您得到了错误。当我禁用并行选项时，它工作正常（ALTER SESSION disable PARALLEL query）。

select * from (
  SELECT o.OBJECT_NAME, o.OBJECT_ID ,'' short_name, NULL partitioned,
                o.sharded,
                case when o.sharded <> 'Y' then o.duplicated else 'N' end duplicated,
                NULL iot_type, 
         o.OWNER OBJECT_OWNER, o.CREATED, o.LAST_DDL_TIME, O.GENERATED, O.TEMPORARY, NULL EXTERNAL
    FROM SYS.Dba_OBJECTS O 
    WHERE O.OWNER = :SCHEMA
    AND O.OBJECT_TYPE = 'TABLE' 
union all
SELECT OBJECT_NAME, OBJECT_ID , syn.SYNONYM_NAME short_NAME, NULL partitioned,
                o.sharded,
                case when o.sharded <> 'Y' then o.duplicated else 'N' end duplicated,
                NULL iot_type, 
       SYN.TABLE_OWNER OBJECT_OWNER, o.CREATED, o.LAST_DDL_TIME, O.GENERATED, O.TEMPORARY, NULL EXTERNAL
              FROM SYS.Dba_OBJECTS O, sys.user_synonyms syn
              WHERE  syn.table_owner = o.owner
              and    syn.TABLE_NAME = o.object_NAME
              and    o.object_type = 'TABLE'
              and    :INCLUDE_SYNS = 1
)

标签： oracleoracle-sqldeveloperoracle12c