Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Oracle DBF files
Name: captmorgan Date: August 23, 2005 at 05:58:49 Pacific OS: Windows 2000 server CPU/Ram: Xeon, 1GB Ram
Comment:
I have DBF files that takes up to 3 Gb of disk space. I was just wondering if I could compress those files with Win 2000 to save some space. Apart from being a little bit slower, will it change anything?
Name: bob819 Date: August 23, 2005 at 07:41:20 Pacific
Reply:
I have a strong suspicion that they will not compress too well but if you DO succeed in zipping them they will, of course, not be available to the Database. If that is acceptable then I suggest you back them up to a DVD until you need them again. Regards.
Bob Mitchell. "There is no reason for any individual to have a computer in their home." - Kenneth Olsen, president and founder of Digital Equipment Corp., 1977.
0
Response Number 2
Name: bob819 Date: August 23, 2005 at 08:21:46 Pacific
Reply:
Ooops! I just re-read your post & realised you are talking about Windows compression which in theory should unpack the file when accessed but retains the file name. I have never used that feature & would be really interested in the result if you try it. I think there is no question it will slow up your Database users but to what degree is what I can't guess at. I think if you have LOTS of surplus memory it may not be too bad, because W2K does the uncompressing in memory, on the fly, I believe. Think I'll go have a look at one of our file servers! Regards.
Bob Mitchell. "There is no reason for any individual to have a computer in their home." - Kenneth Olsen, president and founder of Digital Equipment Corp., 1977.
Summary: I have 4 Windows 98 Machines that access dBase IV files bye SQL on a Windows 2000 Server (the SQL is generic SQL using Lotus Script in Lotus Approach). After these 98 machines query the .dbf files I ...
Summary: They are the database files for Oracle with ".DBF" extension. I don't think the Oracle was running though and before copying, i killed all the running programs found in system tray. There is another s...
Summary: Hi all, I am working with Oracle db backup and what I am trying to accomplish is to find an error message string in the temp. log file (cold_backup.txt) that the backup routine creates. In either case...