| temporary tablespace issue [message #529583] |
Wed, 02 November 2011 01:23  |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
Dear all,
I created a new temporary tablespace tmp_tps,and alter database make it to be the default temporary tablespace,then i want to make the old temp tablespace offline,but failed,why?
Create Temporary Tablespace tmp_tps
Tempfile 'D:\ORACLE\ORADATA\ORCL\TEMP02.DBF' Size 100m;
Alter Database Default Temporary Tablespace tmp_tps;
SQL> alter temporary tablespace temp Offline;
alter temporary tablespace temp Offline
*
ERROR at line 1:
ORA-00940: invalid ALTER command
|
|
|
|
|
|
| Re: temporary tablespace issue [message #529607 is a reply to message #529593] |
Wed, 02 November 2011 02:57  |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
hi,
Michel,it can not make temporary tablespace offline,but can make all the tempfile of a tablespace offline,it it right?
SQL> ALTER TABLESPACE temp TEMPFILE Offline;
Tablespace altered.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
