dreamyb110 comments

Repositories
Issues
Comments

Results 1 comments of


                                            dreamyb110

转换时报如下错误：ORA-12516: TNS:listener could not find available handler with matching protocol stack

库表有300个左右，数据有500M。加这个进程数还是会连接数用完异常。看了一下源代码，是多线程引起的。另外这几个查不到数据，因为大小写不对应，需要改为大写比较或小写比较 select count(*) from user_tab_columns where UPPER(table_name)=UPPER('%s') SELECT A.COLUMN_NAME,A.DATA_TYPE,A.CHAR_LENGTH,case when A.NULLABLE ='Y' THEN 'YES' ELSE 'NO' END as isnull, LONG_TO_CHAR(A.TABLE_NAME,A.COLUMN_ID) DATA_DEFAULT,case when A.DATA_PRECISION is null then -1 else A.DATA_PRECISION...