466 Star 4.5K Fork 825

robergroup / chiner

 / 详情

【版本3.5.7】从oracle数据库导入时,报错 ORA-01000: 超出打开游标的最大数

待办的
任务
创建于  
2022-04-08 09:50

【版本3.5.7】
从oracle数据库导入
大概有400多张表,报错日志如下,筛选只取了200张不到时不报错了
2022-04-07 15:06:31.560 [main] DEBUG cn.com.chiner.java.Application - sun.cpu.endian = little
2022-04-07 15:06:31.560 [main] DEBUG cn.com.chiner.java.Application - socksNonProxyHosts = local|.local|169.254/16|.169.254/16
2022-04-07 15:06:31.560 [main] DEBUG cn.com.chiner.java.Application - ftp.nonProxyHosts = local|.local|169.254/16|.169.254/16
2022-04-07 15:06:31.560 [main] DEBUG cn.com.chiner.java.Application - sun.cpu.isalist =
2022-04-07 15:06:31.568 [main] DEBUG cn.com.chiner.java.Application - Heap-Max:910MB
2022-04-07 15:06:31.569 [main] DEBUG cn.com.chiner.java.Application - Heap-Init:128MB
2022-04-07 15:06:31.569 [main] DEBUG cn.com.chiner.java.Application - Heap-Committed:123MB
2022-04-07 15:06:31.569 [main] DEBUG cn.com.chiner.java.Application - Heap-Used:11MB
2022-04-07 15:06:31.569 [main] DEBUG cn.com.chiner.java.Application - init = 134217728(131072K) used = 12310784(12022K) committed = 128974848(125952K) max = 954728448(932352K)
2022-04-07 15:06:31.570 [main] DEBUG cn.com.chiner.java.Application - NoHeap-Max:0MB
2022-04-07 15:06:31.570 [main] DEBUG cn.com.chiner.java.Application - NoHeap-Init:2MB
2022-04-07 15:06:31.570 [main] DEBUG cn.com.chiner.java.Application - NoHeap-Committed:11MB
2022-04-07 15:06:31.570 [main] DEBUG cn.com.chiner.java.Application - NoHeap-Used:10MB
2022-04-07 15:06:31.570 [main] INFO cn.com.chiner.java.Application - ----------------------------------------------------------------------------------------
2022-04-07 15:12:09.797 [main] ERROR cn.com.chiner.java.dialect.impl.DBDialectOracle - 读取数据表I_NPDB_574的字段明细出错
java.sql.SQLException: ORA-01000: 超出打开游标的最大数

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630)
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1011)
    at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1531)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311)
    at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:2089)
    at oracle.jdbc.driver.OracleStatement.executeLargeUpdate(OracleStatement.java:2054)
    at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:2042)
    at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:310)
    at oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:3864)
    at cn.com.chiner.java.dialect.DBDialect.fillTableIndexes(DBDialect.java:307)
    at cn.com.chiner.java.dialect.DBDialect.fillTableEntity(DBDialect.java:155)
    at cn.com.chiner.java.dialect.DBDialect.createTableEntity(DBDialect.java:408)
    at cn.com.chiner.java.command.impl.DBReverseGetTableDDLImpl.fillTableEntities(DBReverseGetTableDDLImpl.java:82)

评论 (1)

蒙特瑞8 创建了任务

这个问题太恶心了,最多一百多二百张,手选嘛?

登录 后才可以发表评论

状态
负责人
项目
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
预计工期 (小时)
参与者(2)
JavaScript
1
https://gitee.com/robergroup/chiner.git
git@gitee.com:robergroup/chiner.git
robergroup
chiner
chiner

搜索帮助