RE: migrating the default temporary tablespace to locally managed

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 18 Aug 2004 21:45:41 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D60E9AE710@EXCHMN3>

Roger - Create the new temp space, change all users to that temp space, then drop the old one. It is difficult, I realize, but you just can't allow yourself to become so emotionally attached, after all the relationship is temporary.

Dennis Williams
DBA
Lifetouch, Inc.

"We all want progress, but if you're on the wrong road, progress means doing an about-turn and walking back to the right road; in that case, the man who turns back soonest is the most progressive." -- C.S. Lewis

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Roger Xu Sent: Wednesday, August 18, 2004 5:25 PM To: oracle-l_at_freelists.org
Subject: RE: migrating the default temporary tablespace to locally managed

I_do_not_think_I_can_drop_it_until_a_new_one_is_made_available? So_what_is_the_exact_procedure_to_convert_temp_tbsp_to_LMT?=20Thanks.

-----Original=20Message-----

From:=20Roger=20Xu=20
Sent:=20Wednesday,=20August=2018,=202004=205:18=20PM To:=20Oracle-L_at_Freelists.=20Org=20(E-mail) Subject:=20migrating=20the=20default=20temporary=20tablespace=20to=20local= ly=20managed

Hi,

In_order_to_do_that,_can_I_drop_and_recreate_the_temp_tbs? Any_better_way_to_accomplish_that?

Thanks,

Roger_Xu

This=20e-mail=20is=20intended=20solely=20for=20the=20person=20or=20entity=20 =

to=20which=20it=20is=20addressed=20and=20may=20contain=20confidential=20an=
d/or=20privileged=20information.=20Any=20review,=20dissemination,=20copyin=
g,=20printing=20or=20other=20use=20of=20this=20e-mail=20by=20persons=20or=20

=
entities=20other=20than=20the=20addressee=20is=20prohibited.=20If=20you=20= have=20received=20this=20e-mail=20in=20error,=20please=20contact=20the=20s= ender=20immediately=20and=20delete=20the=20material.=20

This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20Email=20Security=20System.=20Any=20questions=20please=20call=20=
972-721-8257=20or=20email=20your=20request=20to=20tech_support_at_dp7uptx.com=

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Wed Aug 18 2004 - 21:46:06 CDT