Author |
Message |
Roberto
Joined: 22 Mar 2005 Posts: 3
|
|
DB Zip/Unzip Expert |
|
DB Tools Ver 4.1.46 Created a zip file worth 1.8GB off one oracle server. Trying to unzip it to new oracle server. Got error after a few minutes: Error: Bad zip file (Extract_currentfile)Error-105 occured while unzipping file Was successfully able to unzip said zipped file using winzip. Tried to zipping just one small table. Was able to unzip with no problem. TIA
|
|
Thu Aug 28, 2003 5:50 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
Re: DB Zip/Unzip Expert |
|
How many tables (approximately) were zipped? Can you unzip just individual tables from that huge file? : DB Tools Ver 4.1.46 : Created a zip file worth 1.8GB off one oracle server. : Trying to unzip it to new oracle server. Got error : after a few minutes: Error: Bad zip file : (Extract_currentfile)Error-105 occured while unzipping file : Was successfully able to unzip said zipped file using winzip. : Tried to zipping just one small table. Was able to unzip : with no problem. : TIA
|
|
Thu Aug 28, 2003 8:17 pm |
|
 |
Roberto
Joined: 22 Mar 2005 Posts: 3
|
|
Re: DB Zip/Unzip Expert |
|
: Please do not cross-post. Your message will be answered in DB Tools forum. Sorry about that...I already posted on the other discussion group before I realized I posted it on the wrong group.
|
|
Fri Aug 29, 2003 11:34 am |
|
 |
Roberto
Joined: 22 Mar 2005 Posts: 3
|
|
Re: DB Zip/Unzip Expert |
|
: How many tables (approximately) were zipped? There are about 116 tables : Can you unzip just individual tables from that huge file? Using DB zip/unzip I got the same error. And i picked one table that is fairly small.
|
|
Fri Aug 29, 2003 11:44 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
Re: DB Zip/Unzip Expert |
|
I will email you a diagnostic version of the zip DLL that will provide more detailed error description. I hope that will help to pinpoint the cause of problem. I should get a hold of this file later today or at the latest tomorrow morning. : There are about 116 tables : Using DB zip/unzip I got the same error. And i picked one : table that is fairly small.
|
|
Fri Aug 29, 2003 12:08 pm |
|
 |
Roberto
Joined: 22 Mar 2005 Posts: 3
|
|
Re: DB Zip/Unzip Expert |
|
: I will email you a diagnostic version of the zip DLL that will provide more : detailed error description. I hope that will help to pinpoint the cause of : problem. I should get a hold of this file later today or at the latest : tomorrow morning. Thanks. I appreciate your help and prompt response.
|
|
Fri Aug 29, 2003 2:07 pm |
|
 |
Roberto
Joined: 22 Mar 2005 Posts: 3
|
|
Re: DB Zip/Unzip Expert |
|
: I will email you a diagnostic version of the zip DLL that will provide more : detailed error description. I hope that will help to pinpoint the cause of : problem. I should get a hold of this file later today or at the latest : tomorrow morning. I ran the unzip again and got this error: Error: Bad zip file (extract_currentfile)Error-105 occured while unzipping files. Additional info: (closecurrentfile) Error-105 occured while extracting UPS.I_SHIPMENT.DATA I_SHIPMENT is a very large table. 2,858,000 plus rows and counting. thanks
|
|
Wed Sep 03, 2003 2:39 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
Re: DB Zip/Unzip Expert |
|
Can you extract that table using WinZip? : I ran the unzip again and got this error: Error: Bad zip file : (extract_currentfile)Error-105 occured while unzipping files. : Additional info: (closecurrentfile) Error-105 occured while : extracting UPS.I_SHIPMENT.DATA : I_SHIPMENT is a very large table. 2,858,000 plus rows and counting. : thanks
|
|
Wed Sep 03, 2003 4:53 pm |
|
 |
Roberto
Joined: 22 Mar 2005 Posts: 3
|
|
Re: DB Zip/Unzip Expert |
|
: Can you extract that table using WinZip? Yes.
|
|
Thu Sep 04, 2003 12:00 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
Re: DB Zip/Unzip Expert |
|
It appears that we sent you another version of the zip routines DLL which is based on Zlib 1.1.4 same as in WinZip. Have you tried that version yet? : Can you extract that table using WinZip?
|
|
Thu Sep 04, 2003 12:11 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
Re: DB Zip/Unzip Expert |
|
It appears that we sent you another version of the zip routines DLL which is based on Zlib 1.1.4 same as in WinZip. Have you tried that version yet? : Yes.
|
|
Thu Sep 04, 2003 12:25 pm |
|
 |
Roberto
Joined: 22 Mar 2005 Posts: 3
|
|
Re: DB Zip/Unzip Expert |
|
: It appears that we sent you another version of the zip routines DLL which is : based on Zlib 1.1.4 same as in WinZip. Have you tried that version yet? I got an email with the attachment "24x7srv.dll" that I put in the db tools install directory. It still failed, only this time it stated which table it has having problem with. Error message I got after using new 24x7srv.dll: Error: Bad zip file (extract_currentfile)Error-105 occured while unzipping files. Additional info: (closecurrentfile) Error-105 occured while extracting UPS.I_SHIPMENT.DATA As a test I zipped and unzipped using DB tools all tables except for 2 very large tables. That went fine. Then I did just the 2 large tables by themselves. This one failed.
|
|
Thu Sep 04, 2003 3:48 pm |
|
 |
|