注册

查询DDL报错:dm.jdbc.driver.DMException: [DBMS_METADATA.MD_FILL_DDL] Readonly transaction

睡姿决定发型 2024/05/16 572 15 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM DatabaseServer 64 V8, JDBC版本: DmJdbcDriver18-8.1.3.62.jar
【操作系统】:X86
【CPU】: 32
【问题描述】*:正常使用建了一些元数据, 在使用下面的语句时候报错了

2024-05-15 10:46:21 ERROR 28651 --- [评估线程1 migr-001 UID:698] com.sics.migrate.util.JdbcUtil : 执行SQL异常: SELECT obj.OBJECT_NAME || '_' || obj.OWNER|| '_' ||obj.OBJECT_TYPE AS objectName ,dbms_metadata.get_ddl(obj.object_type,obj.object_name ,obj.owner) AS DDL FROM DBA_objects obj LEFT JOIN DBA_INDEXES idx ON obj.OBJECT_NAME =idx.INDEX_NAME AND obj.owner = idx.OWNER WHERE obj.OWNER IN ('DSJ') AND obj.OBJECT_TYPE IN ('SYNONYM') AND obj.OBJECT_NAME in('DAMENG_SYN_TEST1', 'TEST1') and (obj.OBJECT_TYPE ='INDEX' or obj.STATUS in ('VALID') )

image.png

回答 0
暂无回答
扫一扫
联系客服