3 Replies Latest reply: Feb 26, 2013 5:54 PM by Aman.... RSS

    resize tablespace and datafile

    991741
      can u explain resize the datafile with autoextend option and resize temp tablespace
        • 1. Re: resize tablespace and datafile
          sb92075
          988738 wrote:
          can u explain resize the datafile with autoextend option and resize temp tablespace
          http://www.lmgtfy.com/?q=oracle+resize+datafile
          • 2. Re: resize tablespace and datafile
            Rob_J
            you can resize a datafile to a size that you specify.
            Autoextend allows your datafiles to automatically increase in size when they become full, to the maximum size of the datafile.

            resize of TEMP tablespace is the same as any other tablespace, you extend the tempfiles (tempfiles are different to datafiles, however).

            What is it that you are not sure of?
            • 3. Re: resize tablespace and datafile
              Aman....
              988738 wrote:
              can u explain resize the datafile with autoextend option and resize temp tablespace
              Please mention all the time your db version and o/s info along with the question. Exactly what you want to know about the resize clause to be explained?

              Aman....