3 Replies Latest reply: Feb 12, 2013 5:42 AM by 973374 RSS

    About Temporary Tablespace

    973374
      Hi DBA Guru(s),
      I have a general query about Temporary Tablespace that,
      if we drop the temporary tablespace then out database will run or not and
      also what will be the impact on database.

      Please suggest.

      Regards,
      Rajeev Kumar
        • 1. Re: About Temporary Tablespace
          Osama_Mustafa
          970371 wrote:
          Hi DBA Guru(s),
          I have a general query about Temporary Tablespace that,
          if we drop the temporary tablespace then out database will run or not and
          also what will be the impact on database.

          Please suggest.

          Regards,
          Rajeev Kumar
          Database can start without Temp Tablespace but it will not be good idea since because the system tbs is used for sort segment.
          • 2. Re: About Temporary Tablespace
            415289
            970371 wrote:
            Hi DBA Guru(s),
            I have a general query about Temporary Tablespace that,
            if we drop the temporary tablespace then out database will run or not and
            also what will be the impact on database.

            Please suggest.

            Regards,
            Rajeev Kumar
            Database will run but query will get fail which required temp space(for sorting..etc) from temporary tablespace.
            • 3. Re: About Temporary Tablespace
              973374
              Hi,
              Thanks for your valuable answer.

              Regards,
              Rajeev Kumar