Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2005
    Posts
    3

    Unanswered: clubbing of datafiles in a tablespace

    hi all,

    i have a doubt with oracle datafiles.. i have 4 datafiles of 2gb each in a single tablespace.. i would like to club all these 4 into a single datafile .. is it possible to do ? and is there any max limit for the size of a single datafile in 32bit version ?

    thanks in advance


    regards,
    nsr

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    32 bit Oracle only supports a max size of 2 gig for a single datafile. Why do you want to combine them into one file, if you could do it, it would make verry little difference in performance.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    32 bit Oracle does allow datafiles bigger than 2GB. Some older versions of Oracle (and certain OSs) did have issues at 2GB and 4GB but I believe they are fixed since 8i and most modern OSs.

    Alan

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    "clubbing"?

    Are we now inventing new buzzwords for the same old concepts?

    Shame, shame.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  5. #5
    Join Date
    Sep 2005
    Posts
    4
    For a definitive answer you are probably best referring to the OS specific Administrators Guide for your release and Oracle version. Any limits are detailed in there.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •