Ron, you're confusing me.
> Perhaps the reason that I was confused is that I did not phrase the
> question correctly. If you create a tablespace to be used as the
> temporary tablespace for users and create it as type temporary (
> segments used by implicit sorts to handle order by clause) you c
Mike,
Perhaps the reason that I was confused is that I did not phrase the
question correctly. If you create a tablespace to be used as the
temporary tablespace for users and create it as type temporary (
segments used by implicit sorts to handle order by clause) you can not
use the LMT clauses. If
Jesse,
I did the same thing last week on our sandbox system using the method others
have prescribed. There is a note 140913.1 covering a LMT bug in 8.1.6.
under OpenVMS. You might want to double check to make sure no equivalent
problem exists on your platform.
Ron,
As Jared pointed out, it's the
o: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Convert TEMP tablespace from datafiles to tempfiles
List,
Would you please explain to me how you are able to get TEMP and LMT
combined together. I use 8.1.7 and it is not allowed.
&
System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
> -Original Message-
> From: Mercadante, Thomas F [mailto:NDATFM@;labor.state.ny.us]
> Sent: Wednesday, November 06, 2002 11:59 AM
> To: Multiple recipients of list ORACLE-L
&
List,
Would you please explain to me how you are able to get TEMP and LMT
combined together. I use 8.1.7 and it is not allowed.
"Oracle8i DBA Handbook" Loney and Theriault, Osborne Oracle Press, Page
598 NOTE
"If you specify Local in a create tablespace command, you can not
specify a default stora
If have the space, create the new TEMP tablespace first, alter all users
that have the old one to now use the new one, drop the old tablespace.
Jared
"Jesse, Rich" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
11/06/2002 07:56 AM
Please respond to ORACLE-L
To: Multiple reci
Rich,
If you've got the disk space, do it while the DB is up. Much simpler.
Create a new Temporary LMT - call it NewTemp - with the appropriate
tempfiles.
Switch everyone to NewTemp by spooling and executing this and running the
spooled file:
Select 'Alter User ' || UserName || ' Temporary Tab
Rich,
I have a better set of steps for you:
1). Create a new tablespace (TEMPLMT) and make it a LMT.
2). One by one, issue ALTER USER {username} TEMPORARY TABLESPACE TEMPLMT;
3). Bounce the database
4). DROP TABLESPACE TEMP INCLUDING CONTENTS;
5). Backup the database
6). Let users at it.
7)