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@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@xxxxxxxxxxx= . ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------