RE: migrating the default temporary tablespace to locally managed
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Aug 2004 21:45:41 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Roger Xu
Sent: Wednesday, August 18, 2004 5:25 PM
To: oracle-l@xxxxxxxxxxxxx
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@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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
