RE: can regular tablespace convert to temporary tablespace???

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Thu, 23 Jul 2009 15:08:30 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F1B35A980_at_AAPQMAILBX02V.proque.st>

No. Just drop it and re-create it as temp, using the same set of datafiles.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Thursday, July 23, 2009 2:56 PM
To: oracle-l_at_freelists.org
Subject: can regular tablespace convert to temporary tablespace???

I by mistake create a "temporary" tablespace as a "regular" tablespace (10GR2).

is it possible I can convert "regular" tablespace to "temporary" tablespace?

thanks.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jul 23 2009 - 14:08:30 CDT

This message: [ Message body ]
Next message: Allen, Brandon: "RE: Stored Outline"
Previous message: Stalin: "Re: Stored Outline"
In reply to: dba1 mcc: "can regular tablespace convert to temporary tablespace???"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message