Oracle tablespace management

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Srini
    #1

    Oracle tablespace management

    In our Oracle installation on SCO Unix, we have reached almost 100% of
    tablespace allocated to Oracle. Now we have deleted a large table from
    the database after taking backup elsewhere.
    [1] Now if we start inserting rows to the table, will the tablespace
    try to grow further or will Oracle utilise the space available because
    of deletion of the table rows.?

    [2] How do we add more space from the Operating system to Oracle
    tablespace?


    Thanks,
    Srini
    Tags: None
    • Mark D Powell
      #2
      Re: Oracle tablespace management

      aone1504@yahoo. com (Srini) wrote in message news:<e5aecd60. 0308120148.1cd0 3e5e@posting.go ogle.com>...
      In our Oracle installation on SCO Unix, we have reached almost 100% of
      tablespace allocated to Oracle. Now we have deleted a large table from
      the database after taking backup elsewhere.
      [1] Now if we start inserting rows to the table, will the tablespace
      try to grow further or will Oracle utilise the space available because
      of deletion of the table rows.?
      >
      [2] How do we add more space from the Operating system to Oracle
      tablespace?
      >
      >
      Thanks,
      Srini
      See the Oracle Concepts manual. Space management is fully explained there.

      HTH -- Mark D Powell --

        Comment

        • Daniel Roy
          #3
          Re: Oracle tablespace management

          Please read a bit about Oracle storage concepts at tahiti.oracle.c om.
          It's important for us to know which version of Oracle you're using,
          since Oracle storage features vary widely from version to version. A
          tablespace (i.e. datafile) can be set to grow automatically or not
          (look at the value of the columns AUTOEXTENSIBLE, MAXBLOCKS of
          DBA_DATA_FILES for the datafiles in your tablespace. Look also at
          EXTENT_MANAGEME NT and ALLOCATION_TYPE of DBA_TABLESPACES to see if
          you're dealing with locally or dictionary-managed tablespaces).
          Depending on your setup, you might need to either create a new
          datafile, or allocate more space to an existing one.

          Daniel
          In our Oracle installation on SCO Unix, we have reached almost 100% of
          tablespace allocated to Oracle. Now we have deleted a large table from
          the database after taking backup elsewhere.
          [1] Now if we start inserting rows to the table, will the tablespace
          try to grow further or will Oracle utilise the space available because
          of deletion of the table rows.?
          >
          [2] How do we add more space from the Operating system to Oracle
          tablespace?
          >
          >
          Thanks,
          Srini

            Comment

            • Shailandra Vaish
              #4
              Re: Oracle tablespace management

              aone1504@yahoo. com (Srini) wrote in message news:<e5aecd60. 0308120148.1cd0 3e5e@posting.go ogle.com>...
              In our Oracle installation on SCO Unix, we have reached almost 100% of
              tablespace allocated to Oracle. Now we have deleted a large table from
              the database after taking backup elsewhere.
              [1] Now if we start inserting rows to the table, will the tablespace
              try to grow further or will Oracle utilise the space available because
              of deletion of the table rows.?
              >
              [2] How do we add more space from the Operating system to Oracle
              tablespace?
              >
              >
              Thanks,
              Srini
              Hi Srini,

              1. New data insert into objects residing on this tablespace will use
              the space created by deletion of rows.
              2. You can always add a datafile from another disk to this tablespace.

              Cheers

                Comment

                • Stephen_CA
                  #5
                  Re: Oracle tablespace management

                  aone1504@yahoo. com (Srini) wrote in message news:<e5aecd60. 0308120148.1cd0 3e5e@posting.go ogle.com>...
                  In our Oracle installation on SCO Unix, we have reached almost 100% of
                  tablespace allocated to Oracle. Now we have deleted a large table from
                  the database after taking backup elsewhere.
                  [1] Now if we start inserting rows to the table, will the tablespace
                  try to grow further or will Oracle utilise the space available because
                  of deletion of the table rows.?
                  >
                  [2] How do we add more space from the Operating system to Oracle
                  tablespace?
                  >
                  >
                  Thanks,
                  Srini
                  Hi,

                  [1] If you merely deleted the rows it will not release the space; if
                  you truncated the table (or dropped and recreated it) it will try to
                  use the space

                  [2] Use the ALTER TABLESPACE command to either:
                  i) resize one or more datafiles that make up the tablespace or;
                  ii) add a datafile to the tablespace

                  Hope this helps,

                  Steve

                    Comment

                    • Srini
                      #6
                      Re: Oracle tablespace management

                      Thank you all for the help.

                      Regards,
                      Srini

                      stephen.bell@sy mpatico.ca (Stephen_CA) wrote in message news:<5aeee507. 0308120816.2ed4 478c@posting.go ogle.com>...
                      aone1504@yahoo. com (Srini) wrote in message news:<e5aecd60. 0308120148.1cd0 3e5e@posting.go ogle.com>...
                      In our Oracle installation on SCO Unix, we have reached almost 100% of
                      tablespace allocated to Oracle. Now we have deleted a large table from
                      the database after taking backup elsewhere.
                      [1] Now if we start inserting rows to the table, will the tablespace
                      try to grow further or will Oracle utilise the space available because
                      of deletion of the table rows.?

                      [2] How do we add more space from the Operating system to Oracle
                      tablespace?


                      Thanks,
                      Srini
                      >
                      Hi,
                      >
                      [1] If you merely deleted the rows it will not release the space; if
                      you truncated the table (or dropped and recreated it) it will try to
                      use the space
                      >
                      [2] Use the ALTER TABLESPACE command to either:
                      i) resize one or more datafiles that make up the tablespace or;
                      ii) add a datafile to the tablespace
                      >
                      Hope this helps,
                      >
                      Steve

                        Comment

                        Previous template Next
                        Working...