| tablespace [message #245793] |
Mon, 18 June 2007 16:28  |
seyiisq
Messages: 125
Registered: September 2005
|
Senior Member |
|
|
i just created a new tablespace called 'UNDO2' using database contol i was expecting this tablespace to have its status to be 'offline'
but when i ran the query below
SQL> select TABLESPACE_NAME, STATUS, SEGMENT_SPACE_MANAGEMENT from dba_tablespaces
2 where
3 TABLESPACE_NAME = 'UNDO2';
TABLESPACE_NAME STATUS SEGMEN
------------------------------ --------- ------
UNDO2 ONLINE AUTO
SQL>
i have the tablespace online. Does it mean that this table space is currently in use other than the formal tablespace created at database creation.
|
|
|
|
| Re: tablespace [message #245795 is a reply to message #245793] |
Mon, 18 June 2007 16:34  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | i just created a new tablespace called 'UNDO2' using database contol i was expecting this tablespace to have its status to be 'offline'
|
did you create it with option offline?
| Quote: | Does it mean that this table space is currently in use other than the formal tablespace created at database creation.
|
No
You have to make it default
ALTER SYSTEM SET UNDO_TABLESPACE=UNDO2;
[Updated on: Mon, 18 June 2007 16:47] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
