Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: migrating the default temporary tablespace to locally managed
Thanks,_Dennis.
Now_the_default_temp_tbsp_got_convert_to_LMT.
I_find_out_it_was_created_1M_uniform_by_default.
Do_you_think_it_is_ok_to_keep_the_default?
Also_which_way_is_better?
Four_10GB_tempfiles_or_one_40GB_tempfile?
TIA. Roger
-----Original=20Message-----
From:=20DENNIS=20WILLIAMS=20[mailto:DWILLIAMS_at_LIFETOUCH.COM]
Sent:=20Wednesday,=20August=2018,=202004=209:46=20PM
To:=20'oracle-l_at_freelists.org'
Subject:=20RE:=20migrating=20the=20default=20temporary=20tablespace=20to=20=
locally
managed
Roger=20-=20Create=20the=20new=20temp=20space,=20change=20all=20users=20to=
=20that=20temp=20space,=20then
drop=20the=20old=20one.=20It=20is=20difficult,=20I=20realize,=20but=20you=20=
just=20can't=20allow
yourself=20to=20become=20so=20emotionally=20attached,=20after=20all=20the=20=
relationship=20is
temporary.
Dennis=20Williams
DBA
Lifetouch,=20Inc.
"We=20all=20want=20progress,=20but=20if=20you're=20on=20the=20wrong=20road=
,=20progress=20means
doing=20an=20about-turn=20and=20walking=20back=20to=20the=20right=20road;=20=
in=20that=20case,
the=20man=20who=20turns=20back=20soonest=20is=20the=20most=20progressive."=
=20
--=20C.S.=20Lewis
-----Original=20Message-----
From:=20oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On=20Behalf=20Of=20Roger=20Xu
Sent:=20Wednesday,=20August=2018,=202004=205:25=20PM
To:=20oracle-l_at_freelists.org
Subject:=20RE:=20migrating=20the=20default=20temporary=20tablespace=20to=20=
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?=3D20Thanks.
-----Original=3D20Message-----
From:=3D20Roger=3D20Xu=3D20
Sent:=3D20Wednesday,=3D20August=3D2018,=3D202004=3D205:18=3D20PM
To:=3D20Oracle-L_at_Freelists.=3D20Org=3D20(E-mail)
Subject:=3D20migrating=3D20the=3D20default=3D20temporary=3D20tablespace=3D=
20to=3D20local=3D
ly=3D20managed
Hi,
In_order_to_do_that,_can_I_drop_and_recreate_the_temp_tbs? Any_better_way_to_accomplish_that?
Thanks,
Roger_Xu
This=3D20e-mail=3D20is=3D20intended=3D20solely=3D20for=3D20the=3D20person=3D=
20or=3D20entity=3D20
=3D
to=3D20which=3D20it=3D20is=3D20addressed=3D20and=3D20may=3D20contain=3D20c=
onfidential=3D20an=3D
d/or=3D20privileged=3D20information.=3D20Any=3D20review,=3D20dissemination=
,=3D20copyin=3D
g,=3D20printing=3D20or=3D20other=3D20use=3D20of=3D20this=3D20e-mail=3D20by=
=3D20persons=3D20or=3D20
=3D
entities=3D20other=3D20than=3D20the=3D20addressee=3D20is=3D20prohibited.=3D=
20If=3D20you=3D20=3D have=3D20received=3D20this=3D20e-mail=3D20in=3D20error,=3D20please=3D20con= tact=3D20the=3D20s=3D
-- Archives=20are=20at=20http://www.freelists.org/archives/oracle-l/ FAQ=20is=20at=20http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please=20see=20the=20official=20ORACLE-L=20FAQ:=20http://www.orafaq.com ---------------------------------------------------------------- To=20unsubscribe=20send=20email=20to:=20=20oracle-l-request_at_freelists.org put=20'unsubscribe'=20in=20the=20subject=20line. -- Archives=20are=20at=20http://www.freelists.org/archives/oracle-l/ FAQ=20is=20at=20http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- For=20technical=20support=20please=20email=20tech_support_at_dp7uptx.com=20or=Received on Thu Aug 19 2004 - 17:25:22 CDT
=20you=20can
call=20(972)721-8257.=20 This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes= sageLabs=20Email=20Security=20System. 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 -----------------------------------------------------------------
![]() |
![]() |