RE: can regular tablespace convert to temporary tablespace???
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "mccdba1@xxxxxxxxx" <mccdba1@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 23 Jul 2009 15:08:30 -0400
No. Just drop it and re-create it as temp, using the same set of datafiles.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of dba1 mcc
Sent: Thursday, July 23, 2009 2:56 PM
To: oracle-l@xxxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
