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.
&
gt; Subject: RE: Convert TEMP tablespace from datafiles to tempfiles
>
>
> 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
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
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Convert TEMP tablespace from datafiles to tempfiles
Hey all,
I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd like
to
take the opportunity to convert the dat
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)
Hey all,
I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd like to
take the opportunity to convert the datafiles of the TEMP tablespace to
tempfiles. My reason for this change is primarily to get the TEMP
tablespace LMT, but also to shrink our hotbacks w/o modifying the working
10 matches
Mail list logo
