Default tablespaces in ORACLE [message #556845] |
Wed, 06 June 2012 23:41 |
|
thiyagusham
Messages: 112 Registered: April 2012 Location: Chennai
|
Senior Member |
|
|
Hi to everyone ;
I check tablespace details. I created database by DBCA. Previously i checked tablespace details on my system
It showed only 5 names(SYSTEM , SYSAUX , USERS , TEMPORARY , UNDO)
Today i issued this query please review this i am much confused
SQL> select ts# , name from v$tablespace;
TS# NAME
---------- ------------------------------
0 SYSTEM
1 UNDOTBS1
2 SYSAUX
4 USERS
3 TEMP
6 EXAMPLE
6 rows selected.
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
** YESTERDAY just showed 5 tablespace names today showing 6 tablespace names
i mean exampe tablespace additionally added. I didn't add anything just created database through DBCA.
* *
Can anyone reply me ???
Thanks and regards
Thiyagusham.G
[EDITED by LF: fixed topic title typo; was "defau;t"]
[Updated on: Thu, 07 June 2012 03:18] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|