Title: RE: Auto Extend

Thanks Kimberly for correcting me.  I had a feeling there was a real reason it was frowned upon in the solaris environment I used to work on (instead of 'just don't do it, I said so') but everything was so overwhemling at that time I just let it go.

LK


    -----Original Message-----
    From:   Kimberly Smith [SMTP:[EMAIL PROTECTED]]
    Sent:   Thursday, May 31, 2001 2:21 PM
    To:     Multiple recipients of list ORACLE-L
    Subject:        RE: Auto Extend

    We had an issue here where we had the Sun box to except files over 2G but got bitten in the ass quickly by it.  We use HP OmniBack to backup all our Unix boxes and the agent on the Sun box could not handle the file size.  So there is more then just "Can the OS handle it" to keep into account.  Thankfully nothing had written to the extra portion and we were able to shrink it again.

      -----Original Message-----
      From: Lisa Koivu [mailto:[EMAIL PROTECTED]]
      Sent: Thursday, May 31, 2001 10:08 AM
      To: Multiple recipients of list ORACLE-L
      Subject: RE: Auto Extend

      Hi Ron,

      do you have large files enabled on your system? What unix are you running?  if large files are not enabled you're going to get an error but I can't tell you what it will be.

      Boy, autoextend reminds me of a monkey running around in your database.  I'd never do that, but it's just my personal preference.

      Lisa Koivu
      Oracle Database Administrator
      954-935-4117

      The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful.

      The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments.



      -----Original Message-----
      From:   Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
      Sent:   Thursday, May 31, 2001 10:31 AM
      To:     Multiple recipients of list ORACLE-L
      Subject:        Auto Extend

      I have taken over an Oracle database that is setup with autoextend on the
      tablespaces.  Can anyone tell me what happens when the datafiles extend
      beyond 2G on Unix?

      .

      --
      Please see the official ORACLE-L FAQ: <http://www.orafaq.com>
      --
      Author: Smith, Ron L.
        INET: [EMAIL PROTECTED]

      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: [EMAIL PROTECTED] (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).

Reply via email to