Re: datafile compression

Keith,

For the backup I am copying db files into 'compressed' directory (so they get compressed while being copied). I recovered db from 'compressed' db files many times (they get automatically de-compressed while being copied from 'compressed' directory into 'normal'), and compression didn't cause any problems.
Though, for some reason I didn't risk to set 'compressed' directory for archived RedoLog files.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, February 07, 2002 6:23 PM

Hello everyone. Let me say first to all who are on the list group THANK YOU.
>From reading the emails I receive I have learned a LOT the past few weeks.

My question here is. I am trying to find a way to compress the datafiles when I copy them to a backup folder on NT. Does anyone have a suggestion as to what product they use to compress datafiles? Has anyone ever used the COMPRESS option on a folder in NT to compress datafiles? If so, was there ever a problem. I did try pkzip and when the files unzipped it gave errors abour the crc checks. I also researched this and didn't find much about compressing datafiles BUT i'm not that good with the oracle doc's yet either.

Thanks in advance for any responses to this email and everyone have a good day.

>>>>>>>>>>>>> Confidentiality Disclaimer <<<<<<<<<<<<<<<<
This email and any files transmitted with it may contain confidential and /or proprietary information in the possession of WellStar Health System, Inc. ("WellStar") and is intended only for the individual or entity to whom addressed. This email may contain information that is held to be privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any unauthorized access, dissemination, distribution or copying of any information from this email is strictly prohibited, and may subject you to criminal and/or civil liability. If you have received this email in error, please notify the sender by reply email and then delete this email and its attachments from your computer. Thank you.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Keith Worley
  INET: Keith.Worley_at_wellstar.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).