2 Replies Latest reply: May 7, 2011 5:57 PM by orawiss RSS

    more 10 TG in One Table

    600272
      I need to store information in a table (they are digital files) can take more than 5 terabytes.

      Oracle allows


      I store information in BLOB fields and rapidly grows in size.
        • 1. Re: more 10 TG in One Table
          orawiss
          Bgr.Oracle wrote:
          I need to store information in a table (they are digital files) can take more than 5 terabytes.

          Oracle allows


          I store information in BLOB fields and rapidly grows in size.
          So What's the question? Could you elaborate please.
          And your Oracle and OS versions?
          • 2. Re: more 10 TG in One Table
            orawiss
            I will assume you are asking if Oracle can handle a Multi - Terabytes BLOB column table,
            The answer is YES, from 8TB to 128TB depending on your DB_BLOCK_SIZE initialization parameter (From 10g version)


            reference:

            http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/limits001.htm#i287903
            http://download.oracle.com/docs/cd/E11882_01/server.112/e17110/limits001.htm#REFRN0041