ERROR [FileOperation] java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.String

最新推荐文章于 2021-11-30 11:03:25 发布

转载最新推荐文章于 2021-11-30 11:03:25 发布 · 1w 阅读

文章标签：

#table #null

本文展示了如何使用SQL查询语句从Oracle数据库中获取特定所有者（CAFFM）的表名、表空间名称及行数信息。通过联合使用ALL_TABLES和ALL_TAB_PARTITIONS视图实现了对普通表和分区表数据的统一检索。

15:26:41,681 INFO [DBOperationOfOracle] select table_name, tablespace_name, num_rows from all_tables where owner = 'CAFFM' and tablespace_name is NOT NULL union select distinct table_name,tablespace_name,num_rows from all_tab_partitions where table_owner = 'CAFFM'
15:26:41,946 INFO [DBOperationOfOracle] select table_name, tablespace_name, num_rows from all_tables where owner = 'CAFFM' and tablespace_name is NOT NULL union select distinct table_name,tablespace_name,num_rows from all_tab_partitions where table_owner = 'CAFFM'
15:29:01,711 ERROR [FileOperation] java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.String