ORA-03113：通信通道的文件结尾-完美解决方案

import os,sysfrom ftplib import FTPfrom mimetypes import guess_typenonpassive = False ????????????????????????????????????????????????????????#passive FTP by defaultremotesite = ‘192.168.191.1‘remotedir = ‘.‘ ???????????????????????????????????????????????????????????#FTP的路径remoteuser = () ???????????????????????????????????????????????????????????#因为我没设置密码，所以为空集localdir = ‘.‘ ????????????????????????????????????????????????????????????#本地路径clean_all = input( ‘Clean local directory first? ‘)[:1] in [‘y‘,‘Y‘] ??????#是否清除本地目录所有文件#连接PFTPprint(‘connecting...‘)connection = FTP(remotesite)connection.login(*remoteuser)connection.cwd(remotedir)if nonpassive: ???connection.set_pasv(False) ????????????????????????????????????????????#most servers do passive#清除if clean_all: ???for localname in os.listdir(localdir): ???????try: ???????????print(‘deleting local‘,localname) ???????????os.remove(os.path.join(remotedir,localname)) ???????except: ???????????print(‘cannot delete‘, localname)count = 0remotefiles = connection.nlst()#只能下载目录中的文件，不能下载目录中的目录for remotename in remotefiles[:5]: ???if remotename in (‘.‘,‘..‘) or not ‘.‘ in remotename:continue ????????????#判断是否目录，这里根据实际情况更改 ???mimetype,encoding = guess_type(remotename) ???mimetype = mimetype or ‘?/?‘ ???mimetype = mimetype.split(‘/‘)[0] ???localpath = os.path.join(localdir,remotename) ???print(‘downing‘,remotename,‘to‘,localpath,end=‘ ‘) ???print(‘as‘,mimetype,encoding or ‘‘) ???#保存文件 ???if mimetype == ‘text‘ and encoding == None: ???????localfile = open(localpath,‘w‘,encoding=connection.encoding) ???????callback = lambda line: localfile.write(line + ‘\n‘) ???????connection.retrlines(‘RETR ‘+remotename,callback) ???else: ???????localfile = open(localpath,‘wb‘) ???????connection.retrbinary(‘RETR ‘+remotename,localfile.write) ???localfile.close() ???count += 1connection.quit()print(‘Done:‘,count,‘file download.‘)

import os,sysfrom ftplib import FTPfrom mimetypes import guess_typenonpassive = False ????????????????????????????????????????????????????????#passive FTP by defaultremotesite = ‘192.168.191.1‘remotedir = ‘RRR‘ ???????????????????????????????????????????????????????????#FTP的路径remoteuser = () ???????????????????????????????????????????????????????????#因为我没设置密码，所以为空集localdir = ‘TTT‘ ????????????????????????????????????????????????????????????#本地路径clean_all = input( ‘Clean local directory first? ‘)[:1] in [‘y‘,‘Y‘] ??????#是否清除远程目录所有文件#连接PFTPprint(‘connecting...‘)connection = FTP(remotesite)connection.login(*remoteuser)connection.cwd(remotedir)if nonpassive: ???connection.set_pasv(False) ????????????????????????????????????????????#most servers do passive#清除if clean_all: ???for remotename in connection.nlst(): ???????try: ???????????print(‘deleting local‘,remotename) ???????????connection.delete(remotename) ???????except: ???????????print(‘cannot delete‘, remotename)count = 0localfiles = os.listdir(localdir)#只能下载目录中的文件，不能下载目录中的目录for localname in localfiles[:5]: ???mimetype,encoding = guess_type(localname) ???mimetype = mimetype or ‘?/?‘ ???mimetype = mimetype.split(‘/‘)[0] ???localpath = os.path.join(localdir,localname) ???print(‘downing‘,localname,‘to‘,localpath,end=‘ ‘) ???print(‘as‘,mimetype,encoding or ‘‘) ???#保存文件 ???if mimetype == ‘text‘ and encoding == None: ???????localfile = open(localpath,‘rb‘) ???????connection.storlines(‘RETR ‘+localname,localfile) ???else: ???????localfile = open(localpath,‘rb‘) ???????connection.storbinary(‘RETR ‘+localname,localfile) ???localfile.close() ???count += 1connection.quit()print(‘Done:‘,count,‘file uploaded.‘)