Home » RDBMS Server » Server Administration » temporary tablespace issue (11.2.0.1)
temporary tablespace issue [message #529583] Wed, 02 November 2011 01:23 Go to next message
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 #529593 is a reply to message #529583] Wed, 02 November 2011 02:11 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe you should not try to guess what could be the correct syntax.
Maybe you should read the documentation before trying to write and execute a command.
Maybe...

Regards
Michel
Re: temporary tablespace issue [message #529607 is a reply to message #529593] Wed, 02 November 2011 02:57 Go to previous messageGo to next message
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.
Re: temporary tablespace issue [message #529612 is a reply to message #529607] Wed, 02 November 2011 03:20 Go to previous message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Correct.

Regards
Michel
Previous Topic: how to offline datafile in no archive mode
Next Topic: ORA-07445: exception encountered: core dump [SIGSEGV] [Address not mapped to object] (merged 7)
Goto Forum:
  


Current Time: Sat Dec 27 19:49:13 CST 2014

Total time taken to generate the page: 0.04631 seconds