Default Undo vs Default Temp tablesapces [message #636610] |
Wed, 29 April 2015 02:03 |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
HI All,
Having a small doubt,
We do setup the default temp tablespace as:
alter database default temporary tablespace temp;
But we do that for UNDO tablespace in SYSTEM level as:
ALTER SYSTEM SET UNDO_TABLESPACE <name>;
Both are releasing the space once shutdown the DB.
Then why we required one in MOUNT level (Alter database...)and One in OPEN level (Alter system...)?
Regards
Muktha
|
|
|
Re: Default Undo vs Default Temp tablesapces [message #636612 is a reply to message #636610] |
Wed, 29 April 2015 02:11 |
John Watson
Messages: 8951 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Can you execute those commands in mount mode? I can't:orclz> startup mount;
ORACLE instance started.
Total System Global Area 788529152 bytes
Fixed Size 3050600 bytes
Variable Size 373293976 bytes
Database Buffers 406847488 bytes
Redo Buffers 5337088 bytes
Database mounted.
orclz> ALTER SYSTEM SET UNDO_TABLESPACE=undotbs1;
ALTER SYSTEM SET UNDO_TABLESPACE=undotbs1
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
orclz> alter database default temporary tablespace temp;
alter database default temporary tablespace temp
*
ERROR at line 1:
ORA-01109: database not open
orclz>
|
|
|
|
|
|
|
|
|
|