RE: Change Default Temporary Tablespace in 8.1.7
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 10 Aug 2004 13:26:46 -0400
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@xxxxxxxxxxxxxxx]
Sent: Tuesday, August 10, 2004 1:08 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx =3D
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Otakar Moucka
Sent: Tuesday, August 10, 2004 12:02 PM
To: oracle-l@xxxxxxxxxxxxx
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
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
