| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Change Default Temporary Tablespace in 8.1.7
Greg is 3/4 right, there is no default temp tablespace in 8i, unless = you count system which you should NOT be using. That does not mean you = can't change a users temporary tablespace.
First, if you don't have a temporary tablespace, create one. The = syntax would be:
create temporary tablespace <name>
tempfile <os spefific> size <what you want>
extent management local uniform extents <again what you want>;
Second for each user you want to move:
alter user <username> temporary tablespace <name>;
Now if what you want to do is move users from one temp tablespace to = another, follow the first two steps & then drop the old temp tablespace = afterwards. Sneaky way to do this:
declare=20
stmt varchar2(200);
begin
for a in (select username from dba_users where temporary_tablespace =
=3D '<old_temp>') loop
stmt :=3D 'alter user '||a.username||' temporary tablespace <new = temp>';
execute immediate stmt;
end loop;
end;
/
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Norris, Gregory T [ITS] [mailto:gregory.t.norris_at_mail.sprint.com]
Sent: Tuesday, August 10, 2004 1:08 PM
To: oracle-l_at_freelists.org
Subject: RE: Change Default Temporary Tablespace in 8.1.7=20
That's a 9i new feature... it doesn't exist in 8.1.7.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org =3D
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Otakar Moucka
Sent: Tuesday, August 10, 2004 12:02 PM
To: oracle-l_at_freelists.org
Subject: Change Default Temporary Tablespace in 8.1.7=3D20
Hello
I have problem with change default temprary tablespace .
I know how it makes in 9i , but i dont know in 8i .
Thanks Ota=3D20
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |