Home » RDBMS Server » Enterprise Manager » tablespace
tablespace [message #245793] Mon, 18 June 2007 16:28 Go to next message
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 Go to previous messageGo to next message
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

Re: tablespace [message #246037 is a reply to message #245793] Tue, 19 June 2007 11:05 Go to previous messageGo to next message
seyiisq
Messages: 125
Registered: September 2005
Senior Member
thanks i got the gist now
Re: tablespace [message #246038 is a reply to message #246037] Tue, 19 June 2007 11:06 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
You welcome!!
Previous Topic: LOG_CHECKPOINT parameters
Next Topic: oracle10g database control
Goto Forum:
  


Current Time: Sat Dec 03 06:18:54 CST 2016

Total time taken to generate the page: 0.08160 seconds